I’m looking to use the line chart to create a budget burndown report in Kantata that works in the following way.
X Axis
- Weekly timeline based on Project Start Date and Project End Date
- Week = Sunday - Saturday
Y Axis
- Target burndown trend line based on Project Hours Estimate / number of weeks between Project Start Date and Project End Date
- Trend line beginning with Project Hours Estimate, populating week over week with Hours Remaining
- Begin with Project Hours Estimate (total available hours)
- Each week, add a data point based on Remaining Hours
Bonus if this can be combo chart with a weekly column to display hours used each week.

Best answer by Julius Kos
View original