topic Re: Avg Daily Unique Users in App Development

Avg Daily Unique Users

cfountain72 — Wed, 02 Mar 2022 14:43:30 GMT

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

Re: Avg Daily Unique Users

Or — Wed, 02 Mar 2022 14:56:51 GMT

Perhaps something like:

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

Re: Avg Daily Unique Users

cfountain72 — Wed, 02 Mar 2022 21:21:10 GMT

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.

Re: Avg Daily Unique Users

Or — Thu, 03 Mar 2022 09:02:46 GMT

Does your chart have weekday as the dimension?