3 Replies Latest reply: Apr 27, 2015 1:23 PM by Ramon Covarrubias RSS

    Don't show previous week until it ends.

      How do I make sure that a chart doesn't show the previous week until it ends.  Week = Sun through Sat.

       

      Example below - I don't want to show week 5/2 until this week completes.

       

      Here is the Expression for the last (most recent) week:

       

      Count({<OwnerTableGroup2 -= Null, [Week End] = {"$(=MAX([Week End]))"} >} DISTINCT GenericId)

      //Count({<[1st Activity Source] -= Null, OwnerTableGroup2 -= Null, [Week End] = {"$(=MAX([Week End]))"} >} DISTINCT [Lead ID])