How To get Average Of Distinct Logins

[jamiemcc]

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

[jamiemcc]

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