Percent of Total Calculation

Question & Answer
, ,
1

Hi Community,

I have a table (see below) and I want to calculate the percent of total for each month/row

image
image494×286 14.3 KB

For example, December 24 should be

column 1: 100%
column 2: 1074/1312 = 82%
column 3: 72/1312 = 5%

I have tried the table calculation but have been unable to isolate the calculation to the row.

Thanks!

1 Like
2

Hello @daynamccue, I know our data isn’t exactly the same, but I think I have 2 different options that you could utilize to solve this issue. The first pivot table is utilizing the table calculation that you can apply directly on the field well, and the 2nd pivot table uses a calculated field to achieve the result.

Percent of Total Calculation

Let me know if this helps you achieve what you were looking for, otherwise let me know if you have any further questions. Thank you!

3

hello @daynamccue

have you ever try the formula:
percentOfTotal(aggregated measure, [partition by attributes] )

let me know if it’s work!!

4

Hello @daynamccue, since we have not heard back from you with any remaining questions, I will mark my previous response as the solution. Let me know if you have any follow-up questions on the Arena analysis that I linked and I can guide you further. Thank you!

5

Hi @DylanM @lary_andr

Hope you are doing well.

I have a similar question and seek your urgent help.

Upload to QS Community
Upload to QS Community623×204 52.5 KB

As the attached, can you please help on how to add calculation field to present the population% (for example, the first row of population is 1000, the second row is 2000, total is 3000, how to present a column named population%, to present as row1 is 1000/3000100%, row2 is 2000/3000100%, total is 100%)

BTW, the population here is a calculated field (max of datasize), and under AU, there are many subrows.

And, if there is any chance we can have a call with QS team via Chime within Amazon?

Thanks for your help.

6

Hello @liu_weiwei, could you post this as a new topic in the community? That will ensure you are at the top of the priority list for a response from one of our QuickSight experts and it will make your question easier for us to track.

I also cannot set up a Chime call with the QuickSight team, but you can submit a support ticket.
Here are the steps for opening a support ticket - Creating support cases and case management - AWS Support . If your company has someone who manages your AWS account, you might not have direct access to AWS Support and will need to raise an internal ticket to your IT team or whomever manages your AWS account. They should be able to open an AWS Support case on your behalf

Thank you!

7

Hi @DylanM Thank you so much for your kind reply! I’ll raise the question in new topic. I am in Amazon but not aware of how to contact QS team and if this support ticket can be cut without any risk, I will check this guideline, thanks again!