5 Replies Latest reply: Oct 23, 2015 5:42 AM by Rob Wunderlich RSS

    Conditional filter in expression

    Yvonne Critchell

      I am trying to create a dashboard of benchmarking bar charts.

      I have a filter box to select the client, then I want all the charts to update based on the client selected.

       

      A client may fall into one of either two or three groups.  Is it possible to select the correct group somehow in the chart expression?

       

      FarmFarmType
      Client AOrganic
      Client BOrganic
      Client CConventional
      Client DConventional

       

      So if I want to compare results for those with the same 'farmtype'

      If I select Client A  I want the chart to display only the clients  with Farmtype 'Organic'.

       

      Is this possible?

      Thanks