Gabriel Yeong Posted September 7, 2020 Share Posted September 7, 2020 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. Link to comment Share on other sites More sharing options...
Fabian Duerr Posted September 7, 2020 Share Posted September 7, 2020 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now