5 Replies Latest reply: Apr 13, 2017 12:04 PM by omar bensalem RSS

    Filter Chart using Aggregate function

    Justin Dallas

      Hello Folks,

       

      I have a chart where I compute the aggregate sum for a particular field.  When the value of this field is Equal To or Less Than 0, I don't want this data point to appear in the bar chart.  However, when I put the aggregate function in my Dimension > Field I get "Invalid Dimension"

       

      Below is a picture with arrows pointing to data points that I want hidden.

      HideUs.png

       

      This the aggregate function I am using to determine if a data point should appear or not.

       

      if(

        Sum({<Year = {$(=Max(Year))}>} ChickenWings) - Sum({<Year = {$(=Max(Year-1))}>} ChickenWings) > 0,

        [Bill To ID], Null()

      )

       

      Any help is greatly appreciated.