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

[Anonymous]

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

[jjfabian]

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

[Anonymous]

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.