Forum Discussion
Calculating Uptime
here is the link for the file
https://drive.google.com/open?id=1E-OOUOH2GQhiswg6OBfyX3BsTTFsNEwl
the expected output which i have marked in red are all the blanks in the matrix reports that need a value
so 0.00 would be when i am calculating per month the sum of downtime. if there is no downtime, then i should see 0.00
when i work out the uptime % in the bottom table. i need the calculations to say 100% if there has been no affected downtime for that product for that month,
Ashish_Mathur
thankyou. im trying to get an understand of the unpivot other columns step you applied. my real spreadsheet has many more columns. im trying to understand what i should be pivoting or not?thanks
Hi,
Unpivot all columns other than Start time and End time columns.
thanks for this example! I have looked into this but cannot explain the following:
When enabling Subtotals, the numbers seem off:
Isn't the calculation of the total the average across the row? If yes, then how can the actual total be lower than any of the values in the columns?
Is there a misunderstanding on my part?
Hi,
For that example (as old as 2 years), there may not have been a need to show subtotals. that being said, the result in the Total column does seem wrong. Start a new thread with your data, describe your question and show the expected result.
