Profile Picture

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

Posted By Bob Smith 7 Years Ago

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

Author
Message
Bob Smith
Posted 7 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: 7 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 (256 views, 26.00 KB)
Workload_Example_Sample_Data.JPG (248 views, 13.00 KB)
Bob Smith
Posted 7 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: 7 Years Ago
Posts: 69, Visits: 1
As a sidenote, I've gone ahead and used workflow to further analyze the data. I created a workflow that culls all work year portions for all users and provides running sums. When a task is assigned a sum is calculated for the overall work taking place for that user at that point. When that task expires another sum is calculated for the overall work taking place at that point for that user. Each of these sums takes into account the additional and subtraction of work year portions caused by the start and stop of these tasks.

I will be using that data to chart a line plot. Would be nice to know if there was some way to do this without an extra step of data analysis!

Nevron Support
Posted 7 Years Ago
View Quick Profile
Supreme Being

Supreme Being (3,958 reputation)Supreme Being (3,958 reputation)Supreme Being (3,958 reputation)Supreme Being (3,958 reputation)Supreme Being (3,958 reputation)Supreme Being (3,958 reputation)Supreme Being (3,958 reputation)Supreme Being (3,958 reputation)Supreme Being (3,958 reputation)

Group: Forum Members
Last Active: Last Month
Posts: 2,892, Visits: 3,094

Hi Bob,

Is this still an open issue? If you need assistance please provide us with more details.

Best Regards,
Nevron Support Team



Bob Smith
Posted 7 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: 7 Years Ago
Posts: 69, Visits: 1
I resolved this issue by creating an additional level of analysis via workflow. Unfortunately, it wasn't the solution I was looking for, but I think it would be too difficult / beyond the capabilities of the Nevron SharePoint GUI to reach my desired goal. I'm certain that a coded solution could run the analysis I needed, but it was easier just to process the data one more time and then spit the result into another list.

Take a look at this topic to see the final result: http://forum.nevron.com/shwmessage.aspx?ForumID=13&MessageID=7362



Similar Topics


Reading This Topic