line chart display %

[#1]

Hi Experts,

I need to display a static 100% on this graph. Even whennothing is selected from TPName, the lines should display the utlization for that TPName. E.g. for the below TPName, the graph shoud display at 33% for all codes even if I do not select the  TPName.

Code	TPName	Utilization
		100%
992ZZ	Pjiuaf Irbvmykxlaql	33%
992Z2	Pjiuaf Irbvmykxlaql	33%
992Z4	Pjiuaf Irbvmykxlaql	33%
992Z5	Pjiuaf Irbvmykxlaql	0%

When that specific TPName is selected

When nothing is selected the graph resizes to 5 %

Please help!

[sunny_talwar]

Not sure what your expression is, but assuming it is Count(Measure), you can try like this

Count(Measure)/Count(TOTAL <TPName> Measure)

and make sure that relative is unchecked on the expressions tab for this expression.

[vinieme12]

Have you check Static Min,Static Max values in the Axes tab?

How can the Chart scale DOWN to 5% when one of your dimension values is upto 33%

[#4]

Thanks Sunny and Vineet. Here is the sample QVW.

[#5]

Please see this sample QVW

[sunny_talwar · Accepted solution]

May be this?

sum(Units)/Sum(TOTAL <TPName> {<Code={'992Z2','992Z4'}>}Units)

[#7]

Thanks Sunny. This works in the chart, but this does not display in the graph,.I want the graph to display 38%, 62% curve for this TPName all the time, not just when I select this TPName.