5 Replies Latest reply on Nov 29, 2016 10:23 PM by Shinichiro Murakami

    How to create limit condition on aggregated value in filter card?

    jenn.ng

      I am trying to limit my chart to show only the 6 most recent values based on week. However my week filter is an aggregated calculated field conditioned on year.

      When i try to add a limit to the agg(week) filter (third filter in the box), the option is grayed out causing me to have to manually select the last 6 weeks.

       

      Screen Shot 2016-11-29 at 3.36.02 PM.png

      Screen Shot 2016-11-29 at 3.37.00 PM.png

       

      The calculated field formula for the week field is:

      if not ISNULL(attr(forecast]))

      then attr([Fiscalweek])

      END

       

      The Fiscalweek field has 1-52 weeks but im only interested in the latest value i have which is currently at  week 15. It increments every week by 1. Hence, I needed to create the calculated field take out values that are null (in the future, such as week 16 onwards).