How do I exclude data from being shown on my graph

[jcharles]

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.

[kumarnatarajan · Accepted solution]

Hi,

Try below syntex

=if(WildMatch(STATUSTYPE,'CLOSED*'),null(),STATUSTYPE)

and check the suppress when value is null option

[MK_QSL]

My dimensions are:

     =AGGR(ONLY(<{STATUSTYPE-={‘CLOSED*’}>}STATUSTYPE),STATUSTYPE)

     BRANCH

[sundarakumar]

Try using

if(STATUS_TYPE='Closed',closed,null())

as dimension and check suppress null selecting the new calculated dimenion in the dimesion tab..

-Sundar