Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I was using a table box to display detailed information for "Issues" to show additional fields of info. No calculations are needed.
However, I now have a requirement to only show data for Issues in which ISSUE_STATUS='Open'. Obviously a table box will no longer work, but I couldn't get the result I wanted with a Straight or Pivot table. Suggestions?
My only thought was to select Open from a List Box and code it as a locked bookmark but that doesn't seem right.
Thanks,
Cassandra
Hi,
you have to use the set expression within an aggregation function.
Solution could be:
with either a hidden dummy expression column like Oleg suggested:
or the Only()-aggregation-function as an expression using one of your fields (given this field only has one value per the remaining dimensions/fields):
hope this helps
regards
Marco
The right answer is the Straight Table with a set analysis expression that can be hidden. What was wrong when you tried it?
I'm not sure how set analysis would apply here. I'm not doing a count or sum etc function...
=({$<ISSUE_STATUS={'Open'}>})
How would I hide it? This would be my only expression.
Thanks
Hi,
you have to use the set expression within an aggregation function.
Solution could be:
with either a hidden dummy expression column like Oleg suggested:
or the Only()-aggregation-function as an expression using one of your fields (given this field only has one value per the remaining dimensions/fields):
hope this helps
regards
Marco
Try this -
Only({<[Issue Status]={'Open'}>}[Issue Status]) but ensure all the other fields are used as dimensions so that condition returns only one record.