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)
PFA for some data similar data in it.
Regards, Sai.
@Kakani Sai Please upload the packaged workbook (twbx) that contains the LoDs. If you need to anonymize your data, this post (How to Anonymize Your Data for the Tableau Community Forums – data katie) provides directions. If your data source is on a server or in the cloud, you should create an extract before saving the packaged workbook.