Something like this?
To do this, create a calculated field called Decade with the following formula: INT([Year]/10)*10
This will give you 60, 70, 80, 90, etc.
Right-click on that field and change it to a Dimension. Then drag the field onto the Color card.
See attached workbook. If this answers your question, please be sure to mark this answer as correct. Thanks!
test data.twbx 57.3 KB
Ken, WOW...I spent three hours on this and was not able to do anything like this...I am trying to create an assignment for my students next semester (so I should be able to do the work myself)...The main issue is that I want them to be able to view multiple graphs in the same visualization...and your suggestions is EXACTLY what I need.
I am so grateful for this forum, and I hope someday to be able to contribute back.
Fantastic. Happy to help.
If you would, please mark my answer as correct so others who visit this can see the correct answer quickly and learn from it as well. Thanks!
How do I download the workbook? I do not see one attached.
Sent from my iPad