6 Replies Latest reply on Mar 11, 2013 2:43 PM by Margarita Garcia

# how to display different rates for each member of a dimension in same graph

I want to display trends of a health service utilization by rate (based on population) broken down by age groups. I have a dimension called "age" with different age groups (eg, children, adult, elder).  I have calculated rates for the total and each age group as separate calculated fields. How can I display the different rates all in the same graph?

Also, why can't I apply any quick calculation to the rate calculated fields?

• ###### 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:

http://community.tableau.com/message/202539#202539

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