Average count of a value per day of the week

[Marcushenriquesk]

Basically I have a bar chart with a dimension of =weekday(received_date) which displays the days of the week I.E: monday, tuesday, wednesday etc.. I want the measure to show the average amount of 'ACC_ID' that are received per day of the week. I have a date picker that allows the user to pick a date range. I want for example, a user to select lets say the last 30 days of received_dates and this chart will show on average how many acc_ids we receive each day of the week.

[stevejoyce]

Avg( Aggr( Count(ACC_ID), [received_date]))

That will do a could of ACC_ID for each date and then average those results by you chart dimension, in your case weekday.

[Gorczany]

Find my alternative approach on solution provided by Mahfooj Khan as reference below and stored in attached workbook version 9.3 located in the original thread. liteblue