0 Replies Latest reply: Feb 14, 2017 2:27 AM by Aviad Bein RSS

    Conditional Display on chart with two dimensions

    Aviad Bein

      Hi all,

       

      In Forecast app I've got conditional display so that the user can choose to display objects by Weighted or Unweighted data.

       

      It goes like this:

       

      in the script:

       

      LOAD * INLINE [

          AmountType, AmountTypeDes

          1, Weighted

          2, Unweighted

      ];

       

      so the user can choose display by Filter Pane:

      filterpane.png

       

      and in objects expression:

       

      if(if(SubStringCount(Concat(AmountType,'|'), '1') =1,1,2)=1,sum(WeightedAmount),sum(UnweightedAmount))

       

      NOW, this condition works just fine in most objects, BUT it's not working in Bar Chart with two dimensions.

       

      For example, there is a "Region Amount by Year" Stacked Bar Chart with two dimensions: Year and Region, and the expression above.

       

      but, it's only display sum(UnweightedAmount) values while it's not responding to display choice that made by the Filter Pane (Weighted/Unweighted).

       

      Why so?

       

      Thanks in advance,

      Aviad