I am hoping you might be able to give me some ideas. Attached is an example of some data for our Wireless Program that I am working with. I have tried to visualize this but I can’t see to come up with the right fit. I think the biggest reason I am having issues is because:
Problem 1 – When you look at the number of devices across one month as compared to cost the values are so vastly different.
Problem 2 - Further complicating the manner, is when you look from Org A to Org B or Org C the values are vastly different there as well.
Scaling seems to be an issue that I am contending with.
In my actual viz, I need to show 12 months’ worth of data. For now I would like to show all of the orgs for all 3-4 months and some sort of percentage of difference or a difference month over month.
Hi @Scott Carman -
I am not so clear on what story you are trying to tell with the data, but here are a couple of suggestions.
As for the question on how to compare data points if the absolute magnitudes are vastly separated along the same axis(s), on either your measures # of devices and Total Cost, you can do the following:
- You can use the logarithmic scale on the measure axis. It will make the visual more comparable.
- The other way from business point of view is to pick a measure that is independent of magnitude across the different organizations.
- Based on your two measures, you can create one that is Cost/Unit. That way you can now do an apple-to-apple comparisons across orgs.
- Here is an example along date based on your data. Here you can use the # of Units as the size of the lines to signify the differences in magnitude.
Just my two-cents.
