Avg Daily Unique Users

[cfountain72]

Hello,

I am trying to create bar chart showing average unique users by Day of Week. A portion of my data is below. So the chart would show 11.5 for Sunday,  45 for Mon, etc.

Date	Unique Daily Users	Day Of Week
1/23/2022	13	Sun
1/24/2022	45	Mon
1/25/2022	50	Tue
1/26/2022	48	Wed
1/27/2022	41	Thu
1/28/2022	37	Fri
1/29/2022	15	Sat
1/30/2022	10	Sun
1/31/2022	45	Mon
2/1/2022	53	Tue
2/2/2022	44	Wed
2/3/2022	45	Thu
2/4/2022	47	Fri
2/5/2022	12	Sat

The issue I am having is I need an expression (the data isn't neat like you see above). I tried using count(distinct userid)/count(distinct Date), but that under counts, since the same user could appear in both Monday's data.  

Any suggestions?

Thanks in advance,

Chris

[Or · Accepted solution]

Perhaps something like:

avg(aggr(count(distinct userid),Date))

[cfountain72]

Hi,

Thanks for your reply. Unfortunately, that only yields one value for the bar or line chart, not one for each day of the week.

[Or]

Does your chart have weekday as the dimension?