Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
Rnc2005
New Contributor

Average Logons Per Calendar Day

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 😮

Avg([LogOnTimestamp.autoCalendar.Date])

Thanks in advance,

Newbie

Average Daily.PNG

 

 

 

 

 

 

Labels (2)
1 Solution

Accepted Solutions

Re: Average Logons Per Calendar Day

Not entirely sure, but may be try this

Count([LogOnTimestamp.autoCalendar.Date])/Count(DISTINCT [LogOnTimestamp.autoCalendar.Date])
2 Replies

Re: Average Logons Per Calendar Day

Not entirely sure, but may be try this

Count([LogOnTimestamp.autoCalendar.Date])/Count(DISTINCT [LogOnTimestamp.autoCalendar.Date])
Rnc2005
New Contributor

Re: Average Logons Per Calendar Day

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!

===Update===

I verified with a smaller data set (one month) and it's PERFECT!!! Thanks again!!!