How To get Average Of Distinct Logins

jamiemcc — Sat, 16 Nov 2024 04:03:35 GMT

Hi Guys i Need to get the Week on Week Average for Distinct Logins

Week 45 7526

Week 46 7652

count({< DailyTaskType = {'Counts'} ,Week = {">=$(=Max(Week)-2)<$(=Max(Week))"}>}distinct UserLogin)/8

count({<DailyTaskType = {'Counts'}, Week = {"$(=Max(Week))"}>}distinct UserLogin)

I have This but it is Returning 17% Which is wrong.

It looks Like It cant Sum Up the Distinctive counts each Week and Divide by 8 then Divide by the Last Max Week.

Has any have any ideas?

Regards,

Jamie

Re: How To get Average Of Distinct Logins

jamiemcc — Thu, 21 Nov 2019 09:38:52 GMT

Sorrty dividing by 8 is a mistake I still get 131%