Filter Chart Data

[Anonymous]

Hello

I have a bar chart that sums the value Grade with the dimension being GradingName on the x axis (.e.g. Target, Actual etc.) I only want to display some of the GradingNames on the chart and cannot see how to include just the ones I want. I only want to filter it on the chart as in other areas of the dashboard I use all GradingNames.

Thanks!

[isingh30]

On what basis you want to filter? Please show data or sample application

Thanks

[Anonymous]

The field "txtGradingName" pulls through a number of grading names stored in the database. Please see the chart below, for example I only want to display Attitude to Learning, Homework and Use of English on the chart.

Thanks

[ogster1974]

Either use limitation i.e top 5 etc...

or

make your dimension a calculated dimension in master items something like

If(gradingname={'A', 'B', 'C', 'D'},gradingname, null())

And then exclude the null values.

Regards

Andy

[ogster1974]

So having a calculated dimension

If(txtgradingname={'Attitude to learning ', 'homework', 'Use of english},txtgradingname, null())

And then excluding nulls in your dimension will give you what you need.

Regards

Andy

[Anonymous]

Hi Andy

Thank you very much for your reply. I have tried adding the calculated dimension, however, I receive an "Error in expression" message:

Many thanks

Sean

[_armoco_]

A simple set analysis as the expression perhaps?

Sum({<txtGradingName={'A','B','C'}>}txtGrade)

Where A,B and C will be Grading names

[mikaelsc]

If(match(txtgradingname,'Attitude to learning ', 'homework', 'Use of english'),txtgradingname, null())

not sure what the syntax of andy should be 🙂