7 Replies Latest reply: Oct 26, 2015 4:48 AM by Jeff Cass RSS

    Drop last data point as the 'count' is incomplete?

    Jeff Cass

      Hi all,

       

      I want to remove the last data point from the graph below as is incomplete data (ie the week is incomplete until Saturday) and so skews the average.

       

      last week is not finished.jpg

      Dim = JOB_DATE_A_FINISH_WEEK

      Dim format = 201501 ...201552 (Year/Week)

      expression  =count({< Job_Date_Completed_Year = {'2015'}>} JobCounter  )

       

      Tried 'Max'-1  & 'Maxstring'-1 to limit the set, but without success to date and dimension limits doesn't seem to be the answer either.

       

      Hope this is relatively easy - over to you guys...

       

      J