4 Replies Latest reply on Apr 20, 2017 10:32 AM by Deepak Rai

Level metric - City, state and country level

Dheeraj H Apr 20, 2017 8:52 AM

In tableau, I have to show the sales percentage across all cities with the sales percentage of the state and country side by side.

The report should have 3 columns - City, Sales percent (City), Sales percent(State level), Sales percent (Country level). The state level sales will be same for all cities that come under same state. Same applies to states.

Sales percent = Units sold / Units delivered. This calculation should apply to city, state and country level metrics.

How to achieve this ?

1. Re: Level metric - City, state and country level

Andrew Watson Apr 20, 2017 8:56 AM (in response to Dheeraj H)

Look at using a FIXED formula. For example for State it could be:

SUM({FIXED [State]:SUM([Sales])}) / SUM({FIXED [State]:SUM([Sales])})

Brackets might be out of place but you should get the idea. You would do this for State and Country, don't think fixed would be required for City.
Like Show 0 Likes(0)

Actions
2. Re: Level metric - City, state and country level

Dheeraj H Apr 20, 2017 9:27 AM (in response to Andrew Watson)

Thanks Andrew. I tried this and it should have worked for any other case.

But as my metric calculation has its numerator and denominator from two different data sources, it says level of detail expression does not support multiple data sources.

Is there any other alternative.
Like Show 0 Likes(0)

Actions
3. Re: Level metric - City, state and country level

Andrew Watson Apr 20, 2017 10:30 AM (in response to Dheeraj H)

I'm away from my computer but post a packaged workbook and someone on the forum should be able to pick it up

Sent from Samsung Mobile
Like Show 0 Likes(0)

Actions
4. Re: Level metric - City, state and country level

Deepak Rai Apr 20, 2017 10:32 AM (in response to Dheeraj H)

Hi Dheeraj,
Can you add mock data?
Thanks
Deepak
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community

Level metric - City, state and country level

1. Re: Level metric - City, state and country level

2. Re: Level metric - City, state and country level

3. Re: Level metric - City, state and country level

4. Re: Level metric - City, state and country level

Actions

More Like This