avg aggr count

[ioannagr]

Hi all.

I need to find a count for all distinct WeekDays and then take the avg of that count for each of them

and then make a line chart with the weekdays (Sat, Sun,...etc).

avg(aggr(count({<[status] = {'0', '1'}>} distinct order_id),WeekDay))

I tried this but it's not working. In fact , it returns the same if i just do count({<[status] = {'0', '1'}>} distinct order_id)

Any suggestions?

[sunny_talwar]

Are you saying that if you have 500 orders over 10 Saturdays... you want to see 50 as the average?

[ioannagr]

Look, I think I have it already, it's the last one line from the table and also the one I used for my calculations!

[ioannagr]

Sunny, I guess yes .

[sunny_talwar]

You guess? Are you not sure what you are looking to get? If you are not, then I don't really know how to help you with this my friend.

[y_grynechko]

Okey, just change the name so it is not the WeekDay. Change it to EveryDayIsAWeekDay or what ever to test if it work in you calc later on. 

[ioannagr]

Haha, no, I'm sure.I apologise If I sounded a certain way. Don't get me wrong.

[sunny_talwar]

Lol okay... how about this

Count({<[status] = {'0', '1'}>} DISTINCT order_id)/Count(WeekDay)

[ioannagr]

Tried, but look! Something is off. 😕

[sunny_talwar]

Can you explain why do you think something is off? What was the expectation?