Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
i'm really stuck with this one.
I'd like the graph to be like the one below, but with average counts per hour.
My dimensions are: weekday(scanneddatetime), hour (scanneddatetime)
My measure: count (slideid)
Thanks in advance!
I guess this would mean the average number across multiple dates then?
So instead of just using count(slideid) as measure, maybe you could try with
Count(SlideID)/Count(Distinct DayName(scanneddatetime))
how is this average count defined?
what would be your expected result?
Hi @MarcoWedel
The expected result is the same table, but instead of having the sum of all slideid, I would like the average.
So, now:
- Graph : count of all SlideID, distributed according to weekday and hour (like you can see)
Expected:
-Graph: average count of SlideID, distibuted according to weekday and hour
In other words: average count of SlideID for each hour, grouped by weekday
I guess this would mean the average number across multiple dates then?
So instead of just using count(slideid) as measure, maybe you could try with
Count(SlideID)/Count(Distinct DayName(scanneddatetime))
Hi, i'll try if this works and let you know
Unfortunately I couldn't get it to work, instead I ended up with the following;
This looks like you changed one dimension from weekday to date.
Can you post a small application to demonstrate the issue?
I got it @MarcoWedel !
I didn't include my if statement in the measure & didn't set my dim toi weekday like you set
works perfectly, in hindsight it was a simple adjustment, thanks