agolla2 Member

Ok, thanks for the response. But I have added a new column (Reversal Status) beside each row whether it is a reversal or not (Yes/No). Case Number Reversal Status 123 Yes 123 Yes 341 No 341 Yes Now can I count how many 1,2, 3+ times for each case? I need a single value of sum of cases where only 1 reversal occurred and…

Thanks, the beast modes are now working.

Thank you all @GrantSmith and @Sean_Tully for the answers. I will try these out and will let you know.

Thanks for the response. But getting 'This calculation contained an error' when using below formula. SUM(CASE WHEN STATE = 'Ringing' AND TIME_TO_SEC(AGENT STATE TIME) <= 11 AND LEAD(STATE) OVER (PARTITION BY AGENT NAME ORDER BY DATE, AGENT NAME) = 'Not Ready' THEN 1 ELSE 0 END)

I'm thinking of a series beast mode to achieve this. But not sure how to write it

Can anyone help me with this please?

Thanks for the response. But I have my data like this in table format how to show this in 4-line graphs (each time zone) using a beast mode in the existing dataset rather than creating a new one.

I did not understand the solution, how would my final dataset look?

Thanks for the response, instead of creating an additional dataset can I write a series beast mode formula and achieve this?

Hey David! Thanks for sharing it worked for me. But I'm trying to use these beast mode calculations to do a weighted average like we do in excel. Example of single value weighted average for 2 columns: "=SUMPRODUCT(F48:F70,E48:E70)/SUM(E48:E70)" My question is can we still try to do the weighted average even after using…

Thanks for the response mark. I have tried this approach but ended up lot many rows in the final output dataset. Instead of daily granularity I am trying to do month wise.