Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Are you saying that if you have 500 orders over 10 Saturdays... you want to see 50 as the average?
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!
Sunny, I guess yes .
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.
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.
Haha, no, I'm sure.I apologise If I sounded a certain way. Don't get me wrong.
Lol okay... how about this
Count({<[status] = {'0', '1'}>} DISTINCT order_id)/Count(WeekDay)
Tried, but look! Something is off. 😕
Can you explain why do you think something is off? What was the expectation?