Calculating Row Percentages with Aggregation

Q&A
, , ,
1

Hello,
In this dashboard (Percent of Total_Dec6-2023)

I am trying to calculate the percentage each row contributes to the total. Currently, the percentages being calculated are incorrect (except for the total row). Further, even though I am using a field calculate as “table down” now, whatever percent results in each row, I want to be able to use in another calculated field. So, even if the current state had worked, I would not be able to do that.

What do you suggest I do to fix this?

Thank you in advance.

2

Hi @PhilK,

Here’s my solution:
Calculating Row Percentages with Aggregation (David Wong)

3

I rewrote the calculation for Gross OnDemand. I think it does the same thing as your calculated field but uses fewer functions. I then used LAC-A to calculate the total by grouping by the entire dataset.

1 Like
4

Hello @PhilK !

Was @David_Wong 's suggestion helpful, and if so could you mark their comment as a solution?

It has been a few days since we have heard from you but would still like to help you find a solution!

1 Like
5

I am sorry @duncan, I was on vacation. Before that, I was trying to adapt it to a fuller set of data. I see someone marked it as a solution and I agree with that.

Thank you, @David_Wong !

2 Likes