Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Sorrty dividing by 8 is a mistake I still get 131%