21 Replies Latest reply: Jun 6, 2017 2:52 PM by Sunny Talwar RSS

    Limit Dimensions to Last 5 Years

    Mark Ritter

      I am trying to limit the bars in my chart to only show the last 5 years.


      I have coded this set analysis.  But something is off and not working and I am just not seeing it.




      vCurrentYear = 2017


      I got this set analysis to work.  But it is not what I ultimately want.


      Count({$<[Hire_Date_Most_Recent.autoCalendar.Year] = {">=$(=date(today()-2100))"} >} Employee_ID)