Target Line in Column Chart

[Randolph]

Hello! I am noob with Cognos so please bear with me if the question is trivial.

I have percentage data that I need to put into a column chart, with a target line above the columns; the target line is also comprised of percentage data. The column chart is easy to make but I do not see how to add a target line.

If possible, how do I create the target line? There appears to be no option in the interface.

Thank you!

[BigChris]

Hi Randolph - what version of Cognos are you using?

[lkading]

R5 - I use Excel worksheets to set things like Targets when the data in the system doesn't have a supporting data container.

[MFGF]

Hello! I am noob with Cognos so please bear with me if the question is trivial.

I have percentage data that I need to put into a column chart, with a target line above the columns; the target line is also comprised of percentage data. The column chart is easy to make but I do not see how to add a target line.

If possible, how do I create the target line? There appears to be no option in the interface.

Thank you!

Hi,

If you are using Cognos Analytics 11.1.3 or later, bar and column visualizations have a Target slot you can drop data into.

https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ca_new.doc/c_ca_nf_11_1_3_targetforbarandcolumn.html

Cheers!

MF.