Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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 🙂
can you share sample app with some sample data
Hi,
Are you trying to count the Id's where Type of the Id is Incident?
Then Try count instead of Only.
=Count({$<Type={'Incident'}>}Id)
Sure. Below is the Data, I am using the expression in a table so that the table show only Incident ID and details
ID | Type |
123 | Incident |
112 | Request |
345 | Change |
235 | Incident |
467 | Problem |
123 | Incident |
456 | Request |
Actually I don't want to aggregate the data I want to show only few records in a table so I am using Only() function.
It does not always work that way. Use Count(DISTINCT) to validate the number datapoints included. If the result is greater than 1, Only() will return NULL for the same aggregation
Hi,
PFA.
What is your Dimension?
you have to use set analysis {< Type = {'Incident'} >} in all your chart expressions.
PFA