Home Forums From Data to Dashboards Summer 2022 Discussion 2 (DTDS22) Reply To: Discussion 2 (DTDS22)

#10610
Riley Smith
Participant

Which type of graph do you think is best for showing Flores del Mundo’s membership trends over the course of the year?

A line graph would be the best option for showing membership trends over time as we are more interested in seeing an overall shape of the total year as opposed to individual months. This would allow us to see if there are any particularly interesting changes between months, as well (such as a spike or drop in membership).

Does your answer change if you’re graphing total membership versus employee/spouse/dependent?

A line graph could also be useful here with different colors representing each category, if the goal is to again visualize the whole year as opposed to smaller scale. However, I would argue that a bar graph might be better here in certain instances. For example, the person viewing the dashboard may be interested in seeing if there are any particular times of year where major changes occur in addition or removal of household members from the plan, as that could give some information on planning ahead for seasonal fluctuations.

Does your answer change if you want to show Eastern and Northern on the same graph?

I think in this case, a bar graph would be most visually useful to indicate what portion of memberships come from each location. If each bar is organized by Total/Location1/Location2, we can see the annual trends of each but more importantly we can see if there are patterns of membership at different locations (e.g., does one location tend to host more memberships than the other?). A line graph would make it harder to visualize the part-to-whole relationship.