-
1. Re: how to display different rates for each member of a dimension in same graph
Margarita,
From what you've described, I'm guessing that the difficulty you are having is because each rate is calculated as a different measure. I think the issue could be alleviated if a single calculation gave you the rate and then you could simply use the dimension to slice the data. Would you be able to post a packaged workbook (with dummy data if there is anything sensitive) so we can look at the specifics of your case?
Regards,
Joshua
-
2. Re: how to display different rates for each member of a dimension in same graph
Also, welcome to the forums!
It's a great place with lots of contributors -- Tableau employees, customers, and partners!
Regards,
Joshua
-
3. Re: how to display different rates for each member of a dimension in same graph
Thanks Joshua,
Here is the a sample of dummy data.
Thank you very much!
Margarita
-
4. Re: how to display different rates for each member of a dimension in same graph
Margarita,
One possibility is to use the "Measure Names" / "Measure Values" fields. I've posted your workbook with this approach shown. I started by dragging "Measure Names" to the Color shelf, then filtered out measures I didn't want and manually sorted the remaining.
Looking at your data, you have a lot of columns that represent the same measure, just broken down by different attributes. If you could reshape the data, you might find things even easier. Check out this thread for more detail:
Regards,
Joshua
-
5. Re: how to display different rates for each member of a dimension in same graph
Joshua,
Yes,
I have been strugling with the issue of formatting the population file. The original file looks more like the one you suggest:
date age_group count
1/1/2000 0-5 140
2/1/2000 0-5 100
.....
I reformatted it because I wanted to do trends I thought I needed all grouped into each month/year, but I wasn't sure if this was right...
I am sending you a new workbook with the population file formatted as shown above.
I want to calculate trends of rates using the counts by age and date as denominator. Assuming I use the population file with the counts of measure "age_group" as denominators, and the number of visits in the sample workbook "Sheet 1" I as numerator. What do I display the rates for each age group by date on the same graph?
Thanks,
Margarita
-
6. Re: how to display different rates for each member of a dimension in same graph
Hi Joshua,
I just realized that all I needed was to format the file as you suggested, and now the calculation I need is a simple division. I was complicating things too much.
Thank you,
Margarita