Discussion board where members can get started with Qlik Sense.
Chart: #1 KPI
Display: average logons per calendar day
I'm not sure if I've looked at this too long or what, to me this should be SIMPLE, but it's not.
Total logins 1,385,155 / # of days from beginning of time (2004) to current is 5207 days
I should pull back an average daily of 266, but I'm not...I'm pulling back 41,448 😮
Thanks in advance,
Go to Solution.
Not entirely sure, but may be try this
The result is 275, but that is way closer than what I was getting so perhaps my # of days were off...I'm considering this a VICTORY!!
Thank you so much!
I verified with a smaller data set (one month) and it's PERFECT!!! Thanks again!!!