Percentage of total volume not showing accordingly in Spotfire...
Hi all, I have a question regarding how to report the data I have below.
So for this example, I have Daily data of Apples from 01/01/2020 to 28/02/2020, a total of 60 days.. Other columns captured are Total Volume of Apples for each day and Total Bad apples for each day. We want to find out which days of the week we had the largest number of Bad Apples as a percentage of Total Apples.
So in Excel, I was able to do a pivot with the following tables and Divided the Volume of Bad Apples and Total Apples by 60 days to show how average daily volumes.
I next did a simple division in the bottom last table to show the percentage of Bad Apples/Total Apples. When uploaded to Spotfire, the Total Bad Apple Volume works, but the % is wrong.
Things I have tried:
- Added a calculated column of Daily Bad Apples/ Daily Total Apples but same result as below
- Divided Daily Bad Apples/ Daily Total Apples by 60, but the numbers still do not reflect the Yellow Highlighted cells.
Is there another approach to show the failure rate of Bad Apples to see which day of the week we has the worst performance?
Thanks in advance.
Why are you plotting the sum of percentage? I think you want to have the average of percentage. So try to change the aggregation method on the right y-axis.