Set a filter for category column in bar charts
I'd like to design a report consisting of several bar charts. Every chart should display only one item of the category column. This means that I would need a way to filter my data set for certain attributes before the chart is created.
A group for the category column is not an option because the charts should be arranged horizontal.
I could place a WHERE condition in my SQL statement to perform the filtering. But in this case I would need several database connections with different WHERE conditions in the SQL queries. This is a workaround I'd like to avoid.
The way I would prefer is to generate one SQL query creating the whole result set and perform the filtering for example in the preferences of the chart.