3 Replies Latest reply on Mar 21, 2019 6:25 AM by maneesh.gaddam

# How Can I Achieve Different Levels of Detail with Percent of Total?

I am trending percent of total so by default, each percent of total should be 100% since it's separated by day. I have 3 bar charts, each with dashboard actions. The first, second, and third charts alter the percent of total chart. Additionally, the first chart filters the data in the second chart and third chart, and the second chart filters the data in the third chart as well.

Let's say the total [Count] is highest level. [Count] = 100. If I click on a bar from the first chart, let's call it [A] and say that bar was 50, it should give me the count of [A] / [Count] (50/100 = 50% for that day).

Now since the second chart values are now filtered based on the selection from the first chart, we click on a bar from that second chart. Let's call our selection [B] and say that count was 20. Now I want my percent of total to be [B] / [A]. We should get 20/50 = 40% for that day. (I don't want [B] over the highest level, just the previous level)

Finally third chart is now filtered based on the selection from the second chart. We click on a bar from that chart. Let's call our selection [C] and say the count was 5. Now I want my percent of total to be [C] / [B]. We should get 5/20 = 25% for that day. Once again the previous level.

How can I accomplish all this? I tried a fixed calculation but I can't get it to work properly since it's based on dashboard actions .

• ###### 1. Re: How Can I Achieve Different Levels of Detail with Percent of Total?

Can you take a look at the attached workbook? I tried to do it using couple of LOD functions.

1 of 1 people found this helpful
• ###### 2. Re: How Can I Achieve Different Levels of Detail with Percent of Total?

Hi,

I was looking for it to be done in a trend though dashboard actions. That way they can see how the percents are changing over time through whatever detail they want. This would allow them to identify spikes. Hierarchy would go -> Count > Type > Class > Code. Numerator would be the dashboard action and denominator would be 1 level up.

ex: Code selected count (numerator) / that code's class count (denominator).

ex2: Class selected count (numerator) / that class's type count (denominator)

Type, Class, and Code would be selected through my charts, so there will always be one level above it.