Hello - Tableau Has wonderful feature through which these fields can be merged. If you "Turn On" the filter and then using Pivot you can Pivot the data and using little trick of Date createion, you can build any viz you want. Steps are given below:
Thanks - Manideep
PS: Please let me know, if you need any help
Book1.twbx 26.2 KB
Thanks a lot !
I never used the pivot function. Great ! It works like a charm
Thank you !
FYI. this article maybe of interest >> Preparing Excel Files for Analysis | Tableau Software
Rather than trying to 'reshape' the data as a general rule of thumb - i would always want raw data vs pre-aggregated data
That way I can aggregate as I want, maybe in multiple ways, if its pre-done then I'm only able to display only.
Just a thought...!
I have marked Manideep's answer correct.
Good work Manideep!
Thanks Mark ! I like your Tableau 10 Strory
Thanks Manideep, and thanks for your involvement on the forum
At some point soon I'll have to do an Ambassador spotlight so I was saving it for then... but then I thought, its such a good discussion I should share, I can always repeat myself (i do that a lot!)
FYI. This was a very enjoyable read, learn a lot about a fellow ambassador, and all round good guy
All the best