10 Replies Latest reply: Feb 8, 2017 7:55 PM by Ali Ahmad RSS

    how to create a MTD set analysis

    Jim Chan

      Hi guys,


      I have a data that have key in with future date and data. and i would like apply MTD for a KPI object.  This is my set analysis


      Count({<Day=,Year=, Month=, Quarter=, Week=, Date=, DateNum={">=$(=Num(MonthStart(Max({<Day>}DateNum))))<=$(=Max({<Day>}DateNum))"}>} VISIT_KEY)


      Now... after applying this, i dont understand why the MTD is 3 DEC 2017, that is the last record.


      I would like to set the MTD, to calculate Month to Date, like now, is Feb 2017, suppose the MTD should be from 1 Feb til today 7 Feb.


      How can i get that analysis with the above MTD set analysis?