Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there ,
I am using the if logic in dimension field -
=if((Interval(today()-max(daystart(Session_Start)),'D'))> 90 ,Name)
but its giving me Error in calculated dimension.
Please assist.
My requirement is to show the report when (Interval(today()-max(daystart(Session_Start)),'D')) is greater than 90.
Thanks
@ashmitp869 You need to use aggr function while using any aggregation function in dimension. You can use this expression in measure instead. If you still want to use it in dimension then try below
=aggr(if((Interval(today()-max(daystart(Session_Start)),'D'))> 90 ,Name),Name)
or
aggr(if((Interval(today()-max(daystart(Session_Start)),'D'))> 90 ,Name),Name,Session_Start)
Note: If there are other dimensions in your table, you need to include that as well in aggr function. check suppress null value option for this calculated dimension
@ashmitp869 You need to use aggr function while using any aggregation function in dimension. You can use this expression in measure instead. If you still want to use it in dimension then try below
=aggr(if((Interval(today()-max(daystart(Session_Start)),'D'))> 90 ,Name),Name)
or
aggr(if((Interval(today()-max(daystart(Session_Start)),'D'))> 90 ,Name),Name,Session_Start)
Note: If there are other dimensions in your table, you need to include that as well in aggr function. check suppress null value option for this calculated dimension