Requirement on Bar chart

[chinnu123]

Hi Team,

I have an issue with Stacked bar chart representation. I need to represent a Bar to 100% what ever the value it is if it is 20 also the bar must be shown to 100% but the value point of that bar is 20  if it is 50 also the bar should be shown to 100% only. The value points of that bar is 50. hope understand..

Can any one help on this..

Thanks in Advance

[sunny_talwar]

Lets say you have two dimensions (Dimension1 and Dimension2) and your expression is Sum(Sales)....

Try this:

Sum(Sales)/Sum(TOTAL <Dimension1> Sales)

[chinnu123]

Hi sunny Thanks for replay..

Below is my Expression  and my dimension is month .could you please complete this.

Count({<[Web Application]={'App '}>} [Web Application])/100

[sunny_talwar]

You have only one dimension? and you wish to get 100% for each bar? I am confused, what is the use of that?

[chinnu123]

Though we have one dimension but we have 5 expressions.

For example I have A, B,C,D,E are the 5 expressions and I have a selection object Country In that I have USA, CANADA,RUSSIA etc

If I select CANADA  i have a values for A&B so the bar should show for only A &B but it must be shown to 100%

Is this helpful?

[sunny_talwar]

How about this:

divide each expression by this:

RangeSum(A, B, C, D, E)

Where A will be replaced by your 1st expression and so on...

[chinnu123]

Unfortunately its not working

[sunny_talwar]

Can you share a sample of data with expected output to help you better?