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 (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
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 (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.
I tried that . but it will show No data available.