Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
May be this?
sum(Units)/Sum(TOTAL <TPName> {<Code={'992Z2','992Z4'}>}Units)
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.
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%
Thanks Sunny and Vineet. Here is the sample QVW.
Please see this sample QVW
May be this?
sum(Units)/Sum(TOTAL <TPName> {<Code={'992Z2','992Z4'}>}Units)
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.