Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone
I come to know how to restrict field value in line chart.
I have 5 values in KPI but want to show only 4 values in line chart.
how restrict it?
Thanks.
If you want an expression that specifies what to exclude (and that can be hardcoded) instead of what to include, then you can use the reverse of that Set Analysis expression. For example, if I always want to exclude the Central Region:
=Count({<Region -= {'Central'}>} Investment)
which is another way to say: assign all currently selected values to Region in my temporary data set except for value Central.
Can you post some sample data
Please find attached file
I don't want to show data for Cetral Region.
Check this
i am not able to open in personal edition. Plese share screenshot.
Thanks
In chart add this expression
=Count({<Region={NE,SE,W}>}Investment)
i dont want to do hardcoded. any other solution is there?
I want to used in dimension not in expression
Use this expression in list box instead of selecting a field
=if(match(Region,'NE','SE','W'),Region)