2 Replies Latest reply on Mar 1, 2018 10:52 AM by Ethan Miller

    10.2 Burndown Metrics - Showing total of count when null

    Ethan Miller

      Any help is greatly appreciated. In short, I'm trying to get from the blue line to the red line like in the picture below:

      Burndown.png

      By distinctly counting the UID's below on the Rows shelf and showing date by month on the Columns shelf. (Data found in the attached excel document)

         

      UIDDateComplete?
      ABC-16/25/2018
      ABC-29/13/2018
      ABC-36/21/2018
      ABC-49/13/2018
      ABC-59/13/2018
      ABC-65/15/2018
      ABC-73/21/2018
      ABC-86/21/2018
      ABC-96/21/2018
      ABC-103/21/2018
      ABC-116/21/2018
      ABC-128/16/2018
      ABC-136/21/2018
      ABC-147/30/2018
      ABC-156/25/2018
      ABC-1610/15/2017Y
      ABC-172/20/2018
      ABC-1810/15/2017Y
      ABC-192/20/2018
      ABC-2010/15/2017Y
      ABC-212/20/2018
      ABC-2210/15/2017Y
      ABC-232/20/2018
      ABC-2410/15/2017Y
      ABC-253/21/2018
      ABC-265/13/2018
      ABC-276/21/2018
      ABC-283/21/2018