PasLeChoix
New Member
- Joined
- May 26, 2017
- Messages
- 1
My sheet is simple:
A1: data volumn, a big int like: 19981573933
B1: partition day, a small int like 365, every day has certain amount of data to be processed, total add up to A1
A2: starting date time (could be only time part, like 16:05)
B2: 0 (meaning at the starting point processed days is 0)
A3~Axx: various date time
B3~Bxx: correspondent completed days (up until 365)
I am looking for a chart showing:
X-Axis: time (from A column except A1)
Y-Axis: trend telling the progress
Chart type doesn't matter.
I need the chart can tell when the job will complete.
Bonus is the chart can tell the processing speed (how much data processed per hour).
Thank you very much.
A1: data volumn, a big int like: 19981573933
B1: partition day, a small int like 365, every day has certain amount of data to be processed, total add up to A1
A2: starting date time (could be only time part, like 16:05)
B2: 0 (meaning at the starting point processed days is 0)
A3~Axx: various date time
B3~Bxx: correspondent completed days (up until 365)
I am looking for a chart showing:
X-Axis: time (from A column except A1)
Y-Axis: trend telling the progress
Chart type doesn't matter.
I need the chart can tell when the job will complete.
Bonus is the chart can tell the processing speed (how much data processed per hour).
Thank you very much.