“I have a dataset as below. To calculate the % of downtime of a machine, I sum the ‘inoperancia’ column, and then I check the time that the machine should be operating during the day (‘tempoobjetivo’), and then I divide the ‘inoperancia’ by the ‘tempoobjetivo’. In my dataset, each row is an occurren…

[image] prantika_sinha: 31434 sample solution ←Arena : Click the link to view dashboard / copy underlying analysis. Have updated the arena dashboard further. The updated field validated with date and serie filters but the numbers with ofensor filter looked a bit ambiguous. kindly check out th…

SumOver and representativity

Q&A

prantika_sinha June 19, 2024, 9:33am 4

Hi @Lucas1 ,

Please check the new added field indisp2. Have added a sumOver to the existing calculated field to keep the denom common for row level calculations.

31434 sample solution

Thanks,
Prantika

Topic		Replies	Views
SUMOVER is not working Q&A Business-Intelligence-Engineer	4	340	October 19, 2023
sumOver continues to be unintuitive to use. Why? Q&A calculations	8	1253	February 28, 2022
How can I use the PRE_FILTER for the sumOver function? Q&A analysis , filters , error , calculations	15	5057	May 16, 2023
How to create a SumOver function in QS that subjects to only chosen filters Q&A filters , calculations	15	1402	August 25, 2023
MaxOver Top 10 filter within Calculated Field Q&A analysis , calculations	2	642	January 3, 2023

SumOver and representativity

Related topics