1 Reply Latest reply: Apr 23, 2017 3:27 AM by kushal chawda RSS

    Set Analysis Question

      Hi All,

       

      I have a chart to calculate Average Preview Time ( MTD) with following expression:

      =Sum({<PreviewedFirst={1},CallCentre-={'UNKNOWN'}, Month=, Quarter=, Week=, Day, DateNum={">=$(=Num(MonthStart(Max(DateNum))))<=$(=Max(DateNum))"},DayType={'Working Day'}>}PreviewTime)/sum(timespent). Now when there is no Month(April) selected I get :

      Month not selected.PNG

      But when I select Month (April) then I get this chart and of which is the correct one

      Month selected.PNG

        • Re: Set Analysis Question
          kushal chawda

          may be like

           

          =Sum({<PreviewedFirst={1},CallCentre-={'UNKNOWN'}, Month=, Quarter=, Week=, Day, DateNum={">=$(=Num(MonthStart(Max({<Month=, Quarter=, Week=, Day, DateNum=>}DateNum))))<=$(=Max({<Month=, Quarter=, Week=, Day, DateNum=>}DateNum))"},DayType={'Working Day'}>}PreviewTime)/sum(timespent)