10 Replies Latest reply on Sep 8, 2018 8:22 AM by carlos capella

    How can I filter an aggregated value in a dual axis chart?

    carlos capella



      I have a dual axis chart with the same aggregated value for both axis. I want to filter one value by Year=2017 and the other one by Year=2018.


      I have tried with:

      IF Year='2018' THEN [aggregated value] END      (for one axis)

      IF Year='2018' THEN [aggregated value] END      (for the other one)


      But it returns this error: 'cannot mix aggregated and non-aggregated comparisons or results in IF expressions.


      How can I solve this? I know that one of the workarounds is duplicating the data source, but I can not do it because I need the database to be updated in real time.


      Thanks for your help.