COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: shivani_cog on 09 Dec 2011 09:21:23 PM

Title: stack bar wrong displaying
Post by: shivani_cog on 09 Dec 2011 09:21:23 PM
I have to create a chart with stack bar in a percentage.
There are  4  values  showing in each stack bar.
1) 25%
2)  35 %
3) 45%
4)  55%
The total %  is 155 % but I want it in a total  100%.  How do I fix it?
Thanks for the help.
Title: Re: stack bar wrong displaying
Post by: pricter on 12 Dec 2011 02:25:12 AM
Did you try to use "Stacked 100%" chart?
Title: Re: stack bar wrong displaying
Post by: shivani_cog on 13 Dec 2011 06:17:48 AM
Hi Pricter,
My users don't want 100% Stack.

I have another question.
I am using date prompt (begin date and end date)
How can I see date prompt in a  report instead of opening from prompt page.
I tried moving date prompts in a report page but it still asks me to prompt the date before it opens the report page when I run the report.
I heard that there is a javscript which helps to open the report directly without propmting the date first.
I am creating a dashboard.
Thanks for your help.
Title: Re: stack bar wrong displaying
Post by: pricter on 13 Dec 2011 06:34:06 AM
Firstly is not clear to me what r you trying to achieve with your bar.

Since the total values are 150% in which way will become 100%.

The date prompts r displayed since I assume that the parameters of them are not optional or you have not declare a default selection for them.
Title: Re: stack bar wrong displaying
Post by: shivani_cog on 13 Dec 2011 06:50:24 AM
Hi Pricter,
You are correct about the 100% stack. I have to explain to my user about that.

About date prompt, there is no area to select optional.
Date prompt I use from Cognos Date prompt(default).
Title: Re: stack bar wrong displaying
Post by: pricter on 13 Dec 2011 06:53:43 AM
On the properties of the date prompt under general section there is a property Required set to No for the prompt to be optional.

Moreover in the filter's properties that you use your parameter select Optional in the property Usage
Title: Re: stack bar wrong displaying
Post by: shivani_cog on 13 Dec 2011 06:57:40 AM
Hi Pricter,
Thanks for your answer.
I already tried with  Required set to NO.
I used Default selection date for beginning date and ending date.
It takes me to the main report now. Then I will prompt different date from the main report.