If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

scatter chart in Cognos without aggregation

Started by ricky_ru, 22 Mar 2018 10:20:40 PM

Previous topic - Next topic

ricky_ru

Dears,

I have the following data. I want to make a scatter chart. The point is I do not want it to be like this as the link statements
sum(xValue), sum(yValue) group by Category(Color).
https://www.ibm.com/support/knowledgecenter/en/SSRL5J_1.1.0/com.ibm.swg.ba.cognos.ug_cr_rptstd.10.1.1.doc/c_cr_rptstd_chrts_appndx_scatter_charts.html

Every row in my data is a point which is the interaction of xValue and yValue. So, there are 3 points for AAAA and 3 points for AAAB with different colors. I can not make it in Cognos, spend much time. Do you have any idea? Thanks!

Category(Color)     xValue   yValue
----------------------------------------------
AAAA   2.131395           2.5156788
AAAA   2.5364759   2.9655475
AAAA   2.6820447   4.0005689
AAAB   3.1067035   3.3508535
AAAB   3.1318441   4.0705097
AAAB   3.3125743   3.6886955

Ricky

MFGF

Quote from: ricky_ru on 22 Mar 2018 10:20:40 PM
Dears,

I have the following data. I want to make a scatter chart. The point is I do not want it to be like this as the link statements
sum(xValue), sum(yValue) group by Category(Color).
https://www.ibm.com/support/knowledgecenter/en/SSRL5J_1.1.0/com.ibm.swg.ba.cognos.ug_cr_rptstd.10.1.1.doc/c_cr_rptstd_chrts_appndx_scatter_charts.html

Every row in my data is a point which is the interaction of xValue and yValue. So, there are 3 points for AAAA and 3 points for AAAB with different colors. I can not make it in Cognos, spend much time. Do you have any idea? Thanks!

Category(Color)     xValue   yValue
----------------------------------------------
AAAA   2.131395           2.5156788
AAAA   2.5364759   2.9655475
AAAA   2.6820447   4.0005689
AAAB   3.1067035   3.3508535
AAAB   3.1318441   4.0705097
AAAB   3.3125743   3.6886955

Ricky

What happens if you go to the properties of the query and set the Auto Group & Summarize property to be No?

MF.
Meep!

ricky_ru

I tried that . but it will show No data available.