Forum Discussion
AVS218
5 years agoFrequent Visitor
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
| Project Name | Avg. Price per Year | Total Contract Year |
Project a | £ 20000 | 20 |
| Project b | £ 30000 | 15 |
| Project c | £ 45000 | 25 |
| Project d | £ 65000 | 20 |
| Project e | £ 25000 | 12 |
| Project n | £ 35000 | 15 |
Any idea how to achieve above graphical representation based on these three fields
Hi AVS218 ,
Based on the sample data you provided,
please see the attached file.
The result is based on the expected output you provided.
Hope this idea helps.