5 Replies Latest reply: Aug 30, 2016 12:04 PM by Gabriel Sampol

# Gauge with measure of specific value of the dimension

Hi

I would like put one Gauge that it only show a measure of one dimension value p.e. X.

I have specified in the expresion of measure with an IF, but if there is only the X filter, it is ok, but if i don`t have filters o I have X and oter more, the Gauge don't show anything.

Thank you. Gabriel

• ###### Re: Gauge with measure of specific value of the dimension

Sorry Gabriel, couldn't understand the scenario or problem here.

Do you want your gauge to calculate only if particular values are selected??

Can you post your dimension expression , your calculation expression and screenshots to explain what you need, also confirm what field you are filtering on

• ###### Re: Gauge with measure of specific value of the dimension

Hi Vineeth, thank you, I am going to try explain better. I will use one example

I have these data

 DIM-A DIM-B MEA-A MEA-B X M 1 6 X M 2 6 X M 3 4 Y M 2 7 Y M 5 8 Y N 5 9 Z N 4 0 Z N 3 8 Z N 4 4

I like have one independent gauge for each X, Y & Z DIM-A with the avg of MEA-A and always show the result independently if there are filters o select something.

I have proved with use function if in measure calculate, and I have also proved with put condition in data handling. But it doesn't work like I want.

I attached the example result

• ###### Re: Gauge with measure of specific value of the dimension

use the following expressions in your gauge

for DimA = X

=AVG({<Dim-A=,Dim-A={'X'}>} MEA-A)

DimA = Y

=AVG({<Dim-A=,Dim-A={'Y'}>} MEA-A)

DimA = Z

=AVG({<Dim-A=,Dim-A={'Z'}>} MEA-A)

and Dimension  = Dim-A

• ###### Re: Gauge with measure of specific value of the dimension

Thank you.

• ###### Re: Gauge with measure of specific value of the dimension

Hi Vineeth .Similarly that.

If I need use a specific number (that I know calculate, it will be like a specific number value, more or less like a constant) into expression to calculate a measure.

How can I do?

Thank you.