I have a dataset that lists error codes (total of 47) as strings for reporting days.
2023-01-23 | ‘code1’
2023-01-24 | ‘code42’
2023-01-24 | ‘code2’
2023-01-24 | ‘code3’
2023-01-25 | ‘code12’
2023-01-26 | ‘code5’
Data reaches back 3 years.
Now, for the top 3 error codes YTD I want to show the counts (sums) as well as their respective percentages in a pivot table of a dashboard.
I applied a top 3 filter to a table, but that messes up percentage calculations (top 3 are treated as 100%). What can I do to get the table look like this
Hello @alfred , welcome to the Quicksight community!
What function are you using to get your YTD calculation as a percentage or are you using the table field well aggregations? I am having some trouble recreating the issue in a pivot table I created.
To clarify, when you use the top 3 filter, is your pivot table showing something like below where it totals all of the percentages to 100% of the three Error codes?:
Code - Count - Percentage YTD
Code 1 - 23 - 40%
Code 2 - 22 - 20%
Code 3 - 20 - 20%
I am using the pivot table to get year to date data, and applied a filter that only considers defects that occured YTD (Filter type> relative dates, granularity>days, period>years, range>YTD)
Yes, the sum of the percentages in the table yields 100%, but it should be like around 50%. I used the the Count of the Code and set the calculation to “percent of total” and “table down across”.
I am going to archive this topic since it has been open for an extended period of time. If you would still like assistance with this, or if you have a new Quick Sight question, feel free to post a new topic in the community so you will be at the top of the priority list for a response from one of our Quick Sight experts. Thank you!
