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.
![kaushi2020_1-1695040803379.png kaushi2020_1-1695040803379.png](https://community.qlik.com/t5/image/serverpage/image-id/116497i1907CFEA2FBB72B5/image-dimensions/442x330?v=v2)
Is there any way i can calculate Average.
Expecting this calculation: (7.58k + 8.62k)/2 = 8.1k