Skip to main content

Hi Folk's..

I have a requirement where i had implemented using LOD expression .. now i want to know if there is any other way to achieve. Someone can assist me on this below requirement

Dashboard to be considered in Weekly Agg data level analysis. My self used a LOD followed by {FIXED ID, Week: COUNTD(Event_Dt)} As ⌗Event.

 

Now using ⌗Event calculation.. I'm calculating event count followed by ⌗1Event, ⌗2Events, ⌗3Events followed by calculation ..

⌗1Event = COUNTD(if [entry ]= 1 then 1 else 0 END)

⌗2Events = COUNTD(if [entry ]= 2 then 1 else 0 END)

⌗3Events = COUNTD(if [entry ]= 3 then 1 else 0 END)

 

Alternate approach for LOD implementation For Weekly Aggregated with ID wise CountPFA for some data similar data in it.

 

Regards, Sai.

1 answer
0/9000