Forum Discussion

AVS218's avatar
AVS218
Frequent Visitor
5 years ago
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

Project NameAvg. Price per YearTotal Contract Year

Project a

£ 2000020
Project b£ 3000015
Project c£ 4500025
Project d£ 6500020
Project e£ 2500012
Project n£ 3500015

 

Any idea how to achieve above graphical representation based on these three fields