topic Re: Average count per weekday per hour in App Development

Average count per weekday per hour

Quentinn — Fri, 04 Mar 2022 10:17:02 GMT

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 — Fri, 04 Mar 2022 11:30:35 GMT

how is this average count defined?

what would be your expected result?

Quentinn — Fri, 04 Mar 2022 15:21:59 GMT

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 — Sat, 05 Mar 2022 18:58:53 GMT

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 — Sat, 05 Mar 2022 19:29:56 GMT

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

Quentinn — Tue, 08 Mar 2022 08:36:42 GMT

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

MarcoWedel — Tue, 08 Mar 2022 16:45:16 GMT

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

Quentinn — Wed, 09 Mar 2022 12:46:15 GMT

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