Average unique users till Date

Kaushik2020 — Mon, 18 Sep 2023 12:41:10 GMT

I am doing a calculation based on distinct users per day. below is my script to find average

Num(count({$<Year=, Month=, Day=,
Date={">=$(=date(monthstart(max(Date))))<=$(=date(max(Date)))"}>}
Distinct users)
/
//(max(Date)-min(Date)+1)

Day(max(Date)),'#0').

Currently the Average for 2 days shows - 7658.

when we see the graph it loos as per the attached.

Is there any way i can calculate Average.

Expecting this calculation: (7.58k + 8.62k)/2 = 8.1k

topic Average unique users till Date in App Development