Average count per weekday per hour

[Quentinn]

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!

[MarcoWedel]

how is this average count defined?

what would be your expected result?

[Quentinn]

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

[MarcoWedel · Accepted solution]

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))

[Quentinn]

Hi, i'll try if this works and let you know

[Quentinn]

Unfortunately I couldn't get it to work, instead I ended up with the following;

[MarcoWedel]

This looks like you changed one dimension from weekday to date.
Can you post a small application to demonstrate the issue?

[Quentinn]

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