Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
kaushi2020
Creator II
Creator II

Average unique users till Date

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

Is there any way i can calculate Average. 

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

 

 

 

Labels (2)
0 Replies