nickcorona Member

Howdy @SurfingDataLakes from the connection tour

@Sean_Tully No the unaggregated data appears when I have sorting/filtering applied and when there are none.

@david_cunningham I am rounding my sec_to_time here: And TotalSessionTime is an integer so I am still confused why this is happening

@GrantSmith Is there a way to do this in a table though? I don't see any tooltip or hover options for a table card.

@ArborRose FYI I took this same question to the Brilliance Bar at Domopalooza and multiple experts were stumped and deemed this was not possible with the current technology around window functions. Thanks for your effort.

Thank you for your efforts still. That was a creative way to think of a solution to count only the '2' cumulative sessions. This unfortunately won't work because Cumulative Sessions is a beastmode function which calculates based on a user selected date range so I can't directly reference it's name inside the Repeat…

Yes I removed the brackets and used `` instead

That also throws an error thank you for trying

That also throws a calculation error unfortunately.