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


Author
Message
Bob Smith
Bob Smith
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
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 (518 views, 26.00 KB)
Workload_Example_Sample_Data.JPG (503 views, 13.00 KB)
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search