Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Kaushik2020
Creator III
Creator III

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