SUMOVER is not working

Question & Answer
,
1

Hi,

I want to calculate the sum of Duration for a day for unique combination of EventDate (not date time), Machine and User ID.
I have build a calculated field using sumover : sumOver({Session Duration (Hours)},[{UserID[Logout]},{MachineName[Logout]},{EventDate[Logout]}],PRE_AGG ).

But this not giving me the right output.

image
image941×285 23.8 KB

I want the column encircled in blue (column name : Session Duration Hours) to be used to give output like in yellow ( column name : Exp : Day’s Total Session Duration (hours) )
But using sumover giving the column encircled in RED.

How to write a calculated field for this using SUMOVER or any other function that builds a column.

how-to #sumOver calculations

2

Hi @Abhilash_Pandey ,

if you want the yellow one. wouldnt that be a runningSum?

grafik
grafik935×370 21.7 KB

BG

3

Hi @ErikG

No I don’t want a running sum. As I am using the this calculated column further to calculate efficiency score. For this I want my Duration to be fixed at the userID, machine and eventDate field.

4

Sorry. Had a typo in my dataset, caused some trouble.
But SumOver should work, in general.

sumOver(Duration,[User,Maschine,Date],PRE_AGG )

grafik

5

Hi @Abhilash_Pandey

Did @ErikG 's solution work for you? I am marking the reply as “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight CommunityQ&A Forum!