Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have used set analysis in a dimension to exclude data from my selection and it's working. The only problem is that my graph is showing the data I want (OPENSTATUS) as well as the data I don't want to see on the graph (CLOSEDSTATUS). Please see the attachment. How do I get my graph to not show the CLOSEDSTATUS?
My dimensions are:
=AGGR(ONLY({STATUSTYPE-={‘CLOSED’}>}STATUSTYPE),STATUSTYPE)
BRANCH
My expression is:
=AVG(TODAY() – REPORTEDDATE)
Please help - Thank you.
Hi,
Try below syntex
=if(WildMatch(STATUSTYPE,'CLOSED*'),null(),STATUSTYPE)
and check the suppress when value is null option
Hi,
Try below syntex
=if(WildMatch(STATUSTYPE,'CLOSED*'),null(),STATUSTYPE)
and check the suppress when value is null option
My dimensions are:
=AGGR(ONLY(<{STATUSTYPE-={‘CLOSED*’}>}STATUSTYPE),STATUSTYPE)
BRANCH
Try using
if(STATUS_TYPE='Closed',closed,null())
as dimension and check suppress null selecting the new calculated dimenion in the dimesion tab..
-Sundar