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

Bubble Chart - Data Values

Started by a.chamkeri, 12 Feb 2017 07:03:16 AM

Previous topic - Next topic

a.chamkeri

Hi Guys,

I have a packed Bubble chart on Cognos 11.0.5 Dashboard. I have set Categories and Color by Age-Group and Size by count(ID).
Now bubbles show Age group as the labels. I want to show the Count on each of the bubbles.

Can someone please guide me how to achieve this.

Thanks,
Ajay Chamkeri

Redrichmond

Not sure if you got this working. I created a workaround

1)Create a data item in FM called Total for Age group.

In the calculation have something like  total ([countiddataitem]for [agegroup])

2)Publish the package (I havnt found a way to refresh the package when you are using the dashboard tool (I,m on 11.0.9) , don't know if Iam missing something - will need to play more, I hope you can do it and don't need to close the dashboard and go back in?)

3)Drag in the new data item "Total for Age group" to the top section "bubble"
4)Drag the "age group" data item into the "size" box
5)Drag the "age group" data item into the "Colour" box
6)In the properties switch on the "Display legend"

You will now see the Age group in the legend in different colours , the number in the bubbles.... The top box derives what is displayed in the bubbles. You may need to play with your calculation but it works for me on my Expenses POC data which I use to send to IBM to fix bugs.