Hi
I'm trying to produce an active report in 10.2.2 with a chart filtered by multiple criteria
The chart is a column chart visualisation with
Measure: Income
Category: Provider
The filter criteria are 'subject' and 'income source'. The requirement is to filter by these criteria but not display them on the chart.
I can include them in the query and extra categories of the chart but this changes the grain of the query (as expected). This means the totals of the measure as displayed in the chart is wrong. For example, the income the highest subject is returned rather than the total income for the provider.
So, my question is: Is it possible to have extra items in the query without affecting the aggregated measure?
Cheers
James
Hi James,
Quick sanity check:
1. Build the visualization with just the following and see what result you get:
Measure: Income
Category: Provider
2. Add the following items into Extra Categories and see what result you get:
Extra Category: Subject
Extra Category: Income Source
You should see exactly the same result. If not, let's check to see you're using the right approach in your report.
When using visualizations, you wouldn't use a data deck, as these can only display one card at a time. You'd use a visualization on its own (not within a data deck), and your controls use the FILTER option connecting directly to the visualization, rather than the SELECT option you would use when linking them to a data deck.
Can you tell us exactly how the controls and the visualization are linked? From your description of only seeing the highest subject, it makes me guess a data deck is in play...
Cheers!
MF.
Hi MF
Thanks for replying. The controls are linked directly to the chart but the charts are nested inside a standard deck. I've tried producing it from scratch and the filtering and aggregation works as expected.
Cheers
James