Restrict Field Value in line chart

[Anonymous]

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.

[Anonymous]

If i used this exp =Count({<Region={NE,SE,W}>}Investment) & in future if our client add some other kpi then it will be shown in chart or not?

[Anonymous]

its only example.

[Nagaraju_KCS]

In future if you have more regions, Don't write like this...  Count({<Region={NE,SE,W}>}Investment)

Use like below....  (You want exclude only Central region)

In Script  or Dimension

IF(Region <> 'Central',Region) as Region1

Note: Without Hardcode, it won't work

[shiveshsingh]

Then write this in your calculated dimension, this will only exclude central and not others(new values will not be impacted)

IF(Region <> 'Central',Region) as Region1

[shiveshsingh]

if the values are other than this, Region={NE,SE,W}, then it will not be shown in this expression cz you are hard coding it

[Peter_Cammaert · Accepted solution]

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.

[MK_QSL]

I was about to suggest the same answer but requirements is Parchi wants to achieve at dimension level and not in expression..

I still don't understand why but this is what Prachi said...

[Anonymous]

Perfect.