Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=if([Last Accessed Session] > 45, AppName, null()) This doesnt work as dimension but works as a measure, what am I doing wrong
Here is the output, Test column is expression =if([Last Accessed Session] > 45, AppName, null()) as master dimension, and Filtered apps column is same expression as master measure. Can someone help.
Hi @vgadang1
Attaching a screenshot as the same is working on the side for both dimension and master dimension
Expression:IF([Last Accessed Session]>45,AppName,NULL())
so my Last accessed session is a measure which calculates days since app was reloaded interval(today(2)-daystart(max(LogTimeStamp)),'d'). Is it possible that my calculated dimension is referring to the measure has to do with the problem. I am still struggling with this calcuated dimension.
IS there an alternative solution to this? I just need to filter out the null rows from the table, is there a way to do that with a measure.
Thanks,
Vidya