I have requirement to make a line-bar graph in Answers.
metrics that i have to use are Best price, commit price and Close price
so the there would be a three bar showing data for all the the three metric. And there would be a line in the graph that should start from closed price, then go to Closed price + commit Price value and finally end at the value of summation of all three i.e. Commit+ closed+ best. So it would be a 3 bar and a trend line.
To implement that I have tried using union of 3 report and calculated the sum of the required trend line in the reports. So kind of output that i get is :
Closed price | Commit Price | Best Price | Cumulative total.
1 2 3 1 (only closed amount)
1 2 3 3 (Closed + Commit amount)
1 2 3 6 (Closed + commit + Best amount)
so when i draw the Graph, i get the values of the bar correctly. But the value of line instead of coming as trend shows a dot on the graph with value as 1.
I am not really sure if the approach that i am taking is correct or not , so kindly request to please help me to make the trend line on the graph.