Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Not entirely sure, but may be try this
Count([LogOnTimestamp.autoCalendar.Date])/Count(DISTINCT [LogOnTimestamp.autoCalendar.Date])
Not entirely sure, but may be try this
Count([LogOnTimestamp.autoCalendar.Date])/Count(DISTINCT [LogOnTimestamp.autoCalendar.Date])
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!!!