Table value Calculation by filtered dates

[Yautraiz]

Hello,

I am a bit stuck as I want to make a little table calculation taking into consideration the date I have filtered it by, but don’t know how. So this is what I would like to make:

I filter my query by date (is in the past 1 complete month) and some other filters.

And the values I get back are per weekday and hour, so, for example, i have 20 trips in the last complete month on Mondays at 1 o’clock. But I would like the value to show the average from these 20 trips, meaning that if there were 4 Mondays in the last complete month it would divide by 4 if 5 Mondays then divide by 5.

So then if I later add this to a dashboard that is filtered by date, then this query would change depending on the dashboard filter.

Please let me know if you would need more information.