Hi Guys,
I am displaying multiple charts per page and the charts are appearing in different sizes - heights are ok but the widths are varying in size based on values displayed on y-axis, where smaller y-values causes the chart width to increase relative to others. I tried applying scale and data format and also specified fixed width in Size & Overflow property but had undesired effects. I basically want the width of all charts on the page to be constant regardless of values on y-axis. Any clues?
tks in advance for ur feedbacks ;)
Quote from: bbtresoo on 08 Sep 2014 02:56:48 PM
...and also specified fixed width in Size & Overflow property but had undesired effects...
Hi,
Size and Overflow is exactly the property you need here. You haven't told us what "undesired effects" means? You simply specify the width and height of the chart, and that is the width and height that gets rendered on the page.
Cheers!
MF.
Hi MF,
I have a question about the Cognos bar chart. I have the revenue values in Y-axis in millions (which are displayed like 2,000,000) but i want them to be displayed as 1M, 2M. Could you please help me with that. I was breaking my head for the whole day and couldnt find a solution.
Thanks,
Sakthi
Quote from: sakthi123 on 09 Sep 2014 08:42:35 AM
Hi MF,
I have a question about the Cognos bar chart. I have the revenue values in Y-axis in millions (which are displayed like 2,000,000) but i want them to be displayed as 1M, 2M. Could you please help me with that. I was breaking my head for the whole day and couldnt find a solution.
Thanks,
Sakthi
Hi dude, I took a look on ur pb, I can give u that it gives some headache, Tell me something u really need to display M , the number only isn't sufficient? For example you can display the Number in the chart and display the chart title + Millions in the bracket, it's just a thought
Quote from: MFGF on 08 Sep 2014 04:31:50 PM
Hi,
Size and Overflow is exactly the property you need here. You haven't told us what "undesired effects" means? You simply specify the width and height of the chart, and that is the width and height that gets rendered on the page.
Cheers!
MF.
The matter here isn't really the width and the height of the chart. the matter here is the area inside de chart.
In my case I had to display the top 10 contributors in the chart, it works nice , the area is well filled. when I modify my filter and want to display the top 3, cognos increases automatically the bar width to fill all the chart area. I had in mind to play with conditionnal styles, in order to modify the bar width depending on what values I get but it's not possible, I have limited options with conditionnal styles
Thank you, bbtresoo.
I am okay with displaying it the way you suggest. Could you please tell me how i can do that ?
Thanks again,
Sakthi
Actually, You need to click on ur default measure in the chart and set the properties .
set data format as number
set No.of Decimal Places as 2
set scale as -6
Give it a try and let me know
Hi bbtresoo,
You nailed it. Thanks a lot. It works perfectly as expected. I tried everything earlier but did not know what the scale part does.
Many Thanks,
Sakthi
u welcome :)
Quote from: bbtresoo on 09 Sep 2014 10:33:35 AM
Actually, You need to click on ur default measure in the chart and set the properties .
set data format as number
set No.of Decimal Places as 2
set scale as -6
Give it a try and let me know
Great answer! That gets an "Applaud" from me! :)