I have created a Card for volume by hour.
Now the department wants a card Average volume by hour.
COUNT(`Case Number`) OVER (PARTITION BY HOUR(`Created Date`))
I'm not sure if I'm doing it right as it's creating duplicate Hours and Volume.
I have done it in ETL and getting the result but then I cant do filters as It's a group by function.
I want to do it in the beast mode so I can apply the filters for the drill own.
Anyone has any idea?