6 Replies Latest reply: Aug 7, 2012 7:57 AM by Jonathan Dienst RSS

    Selection in bar/stacked chart question

      Is it possible to set the 'primary' selection on a stacked bar chart when selection is made by selecting an area on the chart?

       

      I have a stacked bar with a count expression, then two dimensions Date and Organisation.

      So, along the bottom of the chart is the date, then the bar is stacked by Organisation.

       

      What I want to do, is select an Organisation area in the chart and show all data for that organisation across dates (i.e., turn it into a single bar chart). 

       

      The default behaviour is to filter on the primary dimension which is Date. I don't want to have to select an organisation in the legend; that isn't intuitive for the user. 3 clicks sort of works, but it becomes messy and unintuitive, so I want to do it in one click only.

       

      thanks!