Hello, my data is at entity time period level, so for the same company, it may have multiple rows in the data representating the different periods. I would like to have a chart that shows the distribution of the difference between the previous month and the current month. For example, some entities changed rating of 2 notches in two months, and some stayed the same etc. Id like to have a chart which shows how many company have changed 2 notches vs 3 vs. 4 etc.
I'd like to know how to do this without first creating the data I needed outside of tabluau. Thanks!
Can you post a sample packaged workbook that forum helpers can use to show you how this could be done? Are you on 8.0 or 8.1?
Also, a mockup or description of the view you hope to create in Tableau would be helpful. There are several ways you could visualize this. I'm having a hard time understanding your scenario without seeing some sample data.