The totals of the POs are based on created date, but add together day over day.
I have a report based on created date but the ask is to see the line continuing to increase over the life of the project - basic math, day one = $5.00, day two =$5 so the graph shows $10, etc.
see this:
Want this
I have the same ask for the story points, just adding them together within the timeframe of the report. it will be run by Week, by month, by sprint, etc.
Team completes the following point values by day
day 1 - 5
day 2 - 15
day 3 - 0
day 4 - 10
so the value after day 4 is 30 on an incline - no going back to zero for day 3
I have set up an example, based on the Resource Allocation table used in PPM
Below is the result, a timeseries widget showing the cumulative sum of the allocated hours over time.
To set this up, follow the following steps:
Indicator source
Create a indicator source on the table, that contains the column (Or a database view)
The condition should be Start date at or before today (Replace Start date with your desired column)
Indicator
Create a indicatpr, make sure it is aggregate is set to Sum, and aggregate on the appropriate field.
Breakdown source / Breakdown / Breakdown Mapping / Job
Now create the breakdown source, in this example on project, breakdown, the mapping to the table.
Add it to a job, and do a historic data collection.
After that, you should be able to create the Dashboard, with a breakdown on project, witch I display in the first screenshot.
Hope this helps! Good luck.
