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 个回答
0/9000