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.

       

      Count({$<[Hire_Date_Most_Recent.autoCalendar.Year]={">=$(=vCurrentYear-5)"}>}EmployeeID)

       

      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)