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.



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



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

        [Bill To ID], Null()



      Any help is greatly appreciated.