Set Analysis

[soha1902]

Hi All,

Its a straightforward question:

I have Status Field in my dimension and one expression.

Status field having values Open,Closed, OnHold,Freeze and Waiting. I want to show all the values except Closed.

For this I wrote below expression in Calculated dimension

Only({<Status -= {'Closed'}>} Status)

It not showing any error message but it not showing the correct value also. Please help

[vardhancse]

Try Only({<Status <> {'Closed'}>} Status)

or

Only({<Status = {"*"} - {'Closed'}>} Status)

[Gysbert_Wassenaar]

Put the condition in the expression instead: Count({<Status-={Closed}>}IssueID).

[vardhancse · Accepted solution]

if we want to give in calculated dimension, then

Aggr(Only({<Status -= {'Closed'}>} Status),Status)