4 Replies Latest reply on Jun 6, 2018 1:16 PM by Adam Terrenzio

    Represent data as a percentage of total

    Adam Terrenzio

      Data looks like this

      Order No.     |     Complete     |     Completed Time

      123                    1                             Jan 5, 1:25pm

      234                    0                              NULL

      345                    1                              Jan 5 2:30

      456                    0                              NULL

       

      The graph I want to create is the total number of completed orders each hour as a percentage of the total number of orders for the day.  I have the completed items counted for the hour they are completed, but I can't figure out how to graph the data as a trend line moving to 100%

       

      2018-06-06 15_46_50-Tableau - progress_pickordercomplete.png

       

      Thanks,

      Adam.