How can I exclude a category in a Pentaho Report Designer column chart?

Question

I need to create a column chart that includes most, but not all, categories from my data set. For example, my data set's categories are {x, y, z} and I need the column chart to display data only for {x,y}. How can I do this in Pentaho Report Designer (PRD)?

Thank you

I'm pretty sure there isn't - you have to make sure the dataset is what PRD expects to display. But I'll watch this with interest to see if there is a proper solution. — Codek, Jan 01 '13 at 20:00

score 1 · Accepted Answer · answered Jan 04 '13 at 16:08

I have successfully excluded a data point in my Pentaho Report Designer (PRD) column chart by doing the following:

Create an Open Formula function: =if([category_name]= "value to be excluded";null(); [category_name])
In the Chart settings where category column is set, select the function you just created as the category.

How can I exclude a category in a Pentaho Report Designer column chart?

1 Answers1