Set Expression

[Anonymous]

Hi,

I am not getting results even when I use correct syntax, could any one help me please

=Only({$<Type={'Incident'}>}Id)

=Only({$<Type={"Incident"}>}Id)

Thank you in advance.

[Mark_Little]

Hi,

With the sample data you have shared and your set analysis it would not work.

ONLY() function is used to return a single value, i.e. when your set analysis will always return a single ID,

What exactly are you wanting returned in your table?

Is it just the ID's where type = Incident?

or something like

MAX({<Type={'Incident'}>}ID)?

Mark

[martinpohl]

you have to use set analysis {< Type = {'Incident'} >} in all your chart expressions.

also suppress 0-values in chart.

[Anonymous · Accepted solution]

My mistake I was creating Dimension instead of Measure with this (=Only({$<Type={'Incident'}>}Id)) expression in a table.

Thank you for all your responses. Have a great day 🙂

[shanky1907]

Some time back i made the same mistake.... That is why i asked you what is your Dimension.

[shanky1907]

If you want to do it in Dimension you can use IF Else...

If(Type='Incident',ID)...And label it as ID