Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Wanted to create a calculated dimension for:
Count the number of Message ID , if (Message Login Date) = (Calendar Month Name)
Regards,
H
if they are in the same table use an if statement in your load scripti.e. if(MLD=CMN,1,0) then in the front end Sum that field
The date fields are from two seperate tables:
(Message Login Date) = (Calendar Month Name)
Thanks,
H
Your expression should be something like Count({$<(Message Login Date) ={ (Calendar Month Name) }>} (Message Login Date))
or sum(if((Message Login Date) = (Calendar Month Name),1,0))