Separated

This was a very straight forward set of graphs to make, which involved making 4 identical copies of the previous Cumulative graph, and then adding a filter option by source:

I also decreased the size of the slicer to that it was on the side of the screen and allowed more room for the graphs, making it easier to read.

Issues to work out:

• Unlike the previous cumulative graph, in which we receive submissions every month, some sources do not submit data every month, which results in gaps in the data. When the X-axis is “Categorical” it looks like the following:

• Which is much harder to read and the points do not match up. The workaround for this was to make the X-axis “Continuous”, which will join up the lines where data is missing, but will not extend to the ends of boundaries of the graph, it also reduces the number of X-axis points from 12 to 3 (when the graph is made bigger it counts up in 2’s):

• I want the data to be in “Categorical” as it shows all the months and looks more full overall, the issue is connecting data when there there is no data that month. I believe the way to fix this is adding a “+0” to the “SubID_Count” measure somehow, so for each month it adds zero regardless of if there is data or not, and will still return a value. Which I hope will join up the line graph and make it more readable.

Combined

Expanding on this, I decided to create a combined chart of the sources by year. So rather than compare each source by each year, I would instead compare the sources against other sources in a given year.

This is essentially the original Cumulative graph, but instead of using “Years” as the legend, I used “Source”. Which now compares the number of SubIDs each source provided within a given year.

Thoughts

Both of these graphs provide useful, yet different insights. The first set of four graphs shows how each Source has done comparative to itself over the years, which can be useful to see when they were submitting more or less. The second combined graph is useful as it illustrates how much that source provides relative to other sources, even if that source submitted less in one year compared to another, was it less than other sources?

These graphs mostly provide some useful insights into each of these sources and may direct us to communicate with some of them if we feel they are submitting less than usual and try to identify issues which may be occurring. Which may have an effect on our funding.