I was trying lag function on a categorical field.
Would someone help me know, if that works.
If it does, I am facing a problem around the same.
I have created 2 fields at dataset level and stored in spice.
Field1 : CampStatus :
Field2 : LagCampStatus :
This one uses an aggregation function.
The lag function works absolutely fine and stores the data in spice well.
But further, in the analysis when I am trying to use the 2 fields together…It’s showing this mismatched aggregation. error.
How is the data field creation method impacting calculation in the analysis?
Could someone please answer?