I want to display linear gauge chart in pivot table like expression, but its showing correct values only if directly select dimension (in this case Cluster).
The segment expressions under the Gauge Settings are calculated across the dataset.
If you don't select any specific cluster the min(_OffshoreMix) will be 0 and max(_OffshoreMix) will be 100. These will not be evaluated for every dimension value but for the current selection and applied across the table.
