2 Replies Latest reply: Mar 7, 2012 4:52 AM by Adotey Kwame

# How do i make the value in a gauge constant to some specific dimensions???

Hi all,

Suppose i have a gauge as an object and i do not want the the value to change of the gauge to change whilst i click on specific dimensions. What expression can i write to effect this instance with three or more dimension.

Thanks

• ###### Re: How do i make the value in a gauge constant to some specific dimensions???

First of all, you could detach the entire chart.

Second, you could try set analysis. You have to ignore your specific dimensions.

E.g. something like

sum({\$<Dim1=, Dim2=, Dim3=>} Sales) / sum({\$<Dim1=, Dim2=, Dim3=>} UnitCount)

or whatever your actual formula is. Important part is the {\$<Dim1=, Dim2=, Dim3=>} part. By just putting a = for each dimension you are telling set analysis to ignore selections in that dimension.

edited by Jakob Fabian

• ###### How do i make the value in a gauge constant to some specific dimensions???

Hi there,

Thanks for sharing the was very helpful indeed but i had a red undulating line even though the expression reads OK.Should i be worried about that?

Kindly find attached a screen shot.