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

Represent data as a percentage of total

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%

Thanks,

Adam.

• 1. Re: Represent data as a percentage of total

Right Click on CNT(Pick...)>Quick Table Calculation>Percent of Total

• 2. Re: Represent data as a percentage of total

That shows a graph, of the same shape, where the points are the % of orders closed in each hour.  Which is an interesting graph, but I want to show the additive progress towards 100% at the end of the day.  i.e. #of orders completed so far from all previous hours.

• 3. Re: Represent data as a percentage of total

Then You need Running Total

1 of 1 people found this helpful
• 4. Re: Represent data as a percentage of total

Ok, so that shows the axis as a count.  Is there a way that I can show it as percentage?  i.e. I already know the orders that still need to be completed, how to I show that as a %?  Can I also show the "guess" as to how much time it will take to get to 100%?