COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: gosoccer on 25 Apr 2016 03:04:33 PM

Title: Column Chart and Comparing Average Completion Time Values
Post by: gosoccer on 25 Apr 2016 03:04:33 PM
Hi guys, :)
I have a requirement to show three Columns in a chart.

Column 1: Deal was contacted
Columns 2: Dealer Sold the Car
Column 3: Dealer Delivered the Car

As you can see in the attachment, that is not that hard and I have the three columns done.

But now, I have to add a Trent line that would show these columns based on the Entire United States Averge
for the same processes shown above (Deal was contacted,Dealer Sold the Car,Dealer Delivered the Car)

SO, my question is how to create the Trent line to show a Comparison between the entire US and the specific State.
Please see attached.

Thank you in advance for your time.