Forum Discussion
Solved
Line Chart visualization based on Avg. Price per year and duration of contract
Hi All, End Solution Expected: I want to show Avg Price on Line chart for each project based on duration of contract Fields I have as per below sample table Pr...
lbendlin
Super User
Super UserYour sample data is missing the date/year column.
Apologies I missed on that... Data will look like below and I have to consider Contract Start Date as Year 1 and then build on that based on Total Contract Duration. i.e. for Project A Contract Start Year as per date is 2019 and duration is 20 years. so my line chart should display £20k price from 2019 to 2039 and so on for other projects.
Eventually we would like to visualize in two ways one displayed in my previous message and one which will show how much all projects cumulatively earn revenue in a specific year e.g. 2025
Project Name | Avg. Price per Year | Contract Start Date | Total Contract Duration |
Project a | £ 20000 | 20/07/2019 | 20 |
| Project b | £ 30000 | 20/01/2020 | 15 |
| Project c | £ 45000 | 20/05/2020 | 25 |
| Project d | £ 65000 | 25/10/2020 | 20 |
| Project e | £ 25000 | 24/02/2021 | 12 |
| Project n | £ 35000 | 22/05/2021 | 15 |