Hi!
Anyone have any success or good ideas for progress monitoring visualizations in Analytics OTHER than indicators? I want to increase my ink-to-white ratio, and indicators aren't sensible when you have 12+ goals to progress monitor. Would love to see the goal vs. actual listed - but I'm struggling with Analytics.
Thanks!
Something i stole from Christopher Cuhel's dynamic pricing dashboard is highlighting a cell when it gets to a certain % of total. Eg: 80-90% is yellow and 90-100% is red. It can really draw the eye to important tasks in an otherwise complex widget.
Here's my seat revenue pivot
Our Marketing team really loves that coloration. I also added a coloration to the section count because sometimes a section would meet the threshold for a dynamic price increase, but it was only one seat. The way I colored it was this:70-80% is yellow to advise the potential is getting close on a section for a price increase. 80-90% is green to advise that that section is now in the threshold and ready for an increase. The section count of 1 seat is read to make it very obvious.
Thanks - I'm not using a pivot so I won't be using this tip this time but I appreciate the note! We're going for a quick read, so I'd like to stick with bar or column charts. But I have used conditional colors on our plans dashboard!(Also if we're talking color, I try my hardest to avoid using red. In my experience, users get anxious when they see red. If people request a stop light color palette, I like using yellow, green and blue (blue meaning goal is exceed) unless I have color blind users, then I use a color blind friendly palette.)
Interestingly we've been having this discussion over at the analytic coffee group.
https://community.tessituranetwork.com/topical_groups/analytics-coffee/f/discussions/23428/picking-great-colors-for-your-visulization-can-make-the-difference-between-confussion-and-clarity
There was a great article in one of the last PASS newsletters https://www.tableau.com/about/blog/2019/9/3-storytelling-color-tips-improve-your-data-visualization