4 Replies Latest reply on Apr 26, 2017 2:12 PM by Jessie Wang

    Count total possible days

    Jessie Wang

      Hello everyone,

       

      I am working on this assignment, user will select data from a filter (in this example: March 1, 2017 - March 11, 2017)

      I want to count the total possible days even there is no data for that day. So basically I am looking for 11 days for every row, that way I can calculate the percentage.

       

        

      Mar 01, 2017Mar 02, 2017Mar 03, 2017Mar 04, 2017Mar 05, 2017Mar 06, 2017Mar 07, 2017Mar 08, 2017Mar 09, 2017Mar 10, 2017Mar 11, 2017
      Person 1 1 1
      Person 2
      Person 3 1 1 1
      Person 4 1
      Person 5 1111 1

       

       

        

      TotalTotal Days%
      2112/11
      0110/11
      3113/11
      1111/11
      5115/11

       

       

      thank you everyone!