Profile Picture

Running Sum Value - Track sum changes over time in line chart

Posted By Bob Smith 11 Years Ago

Running Sum Value - Track sum changes over time in line chart

Author
Message
Bob Smith
Posted 11 Years Ago
View Quick Profile
Forum Guru

Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)

Group: Forum Members
Last Active: 11 Years Ago
Posts: 69, Visits: 1

A worker is assigned work in Work Year portions. If a worker is tasked on a project with 0.5 work years then this means that the worker will use half of his workload to accomplish it.

At no time should a worker be assigned more than 1 work year overall; if a work year has 1.25 Work Years assigned then they are over tasked.

Projects have a "Start Date" and an "End Date". I would like to create a Step Line chart that shows the amount of work assigned to a worker at different dates. If a new project starts, then the sum of assigned work years goes up. If an old project ends, then the sum of assigned work years goes down.

I have attached an image that demonstrates what this might look like; I did not create this example chart using Nevron, I just modified a screenshot of a Nevron Chart using MS Paint. I have also attached an image of some sample data; this is not the same data that is used in the image, but it would suffice for the creation of a chart.



Attachments
Workload_Example.JPG (444 views, 26.00 KB)
Workload_Example_Sample_Data.JPG (425 views, 13.00 KB)



Similar Topics


Reading This Topic