Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to create a table box chart and for one of the available fields "SI Programs" I only want to display 2 specific values (Growth and TBA). The field currently has 8 values but the others are irrevalent to what I am trying to display.
Is there a way to add a fitler like if(SI Programs = 'Growth' or 'TBA', SI Programs)? I cant see how to add an expression as a field in the table box.
Steve
You will need to use a Chart of type Straight Table, and then quite likely Set Analysis in your expression.
Best Regards, Bill
Or create an additional field in the script:
if(match("SI Programs", 'Growth', 'TBA'), SI Programs, null()) as "SI Programs Restricted"
Regards,
Michael
how would I use set analysis for the expression. Not sure what function i would use against the "SI Programs" field since I am just trying to return text values.
maybe max()
For a dimension:
=aggr(only({<[SI Programs]={'Growth', 'TBA'}>}[SI Programs]), [SI Programs])
or
For an expression:
only({<[SI Programs]={'Growth', 'TBA'}>}[SI Programs])
It all depends on how you're setting your table up if you need the dimension or expression.