Gauge with calculated dimension( Budget vs current)

[Korto2024]

Bonjour ,

I have a pivot table that I created which highlights the list of companies, their actuel, Budget ( the two dimmsnion are calculated with set Analyses )

like this :

I want to make a histogram for each company Current vs Budget

Cordialement

[TauseefKhan]

Hi,
Create Variables of that two dimension are calculated with set Analyses i.e. Actual and Budget 

Using those Variables Create a Calculated Dimension: In the sheet editor, create a new calculated dimension with the following expression:

BudgetVsActual:
IF(Actual < Budget, 'Under Budget',
IF(Actual > Budget, 'Over Budget', 'On Budget'))

Create the Gauge Chart:

In the Dimensions section, select the "BudgetVsActual" calculated dimension you created.
In the Measure section, use the following expression:

IF(BudgetVsActual = 'Under Budget', Actual/Budget*100,
IF(BudgetVsActual = 'Over Budget', Actual/Budget*100, 100))

To calculate the percentage value for the gauge chart based on the categorization from the "BudgetVsActual" dimension.

** When applicable please mark the correct/appropriate replies as "solution". Please LIKE threads if the provided solution is helpful to. **

[Korto2024]

Hi thanks for the update and the details, 

i cann't understand where i put this following expression

BudgetVsActual:
IF(Actual < Budget, 'Under Budget',
IF(Actual > Budget, 'Over Budget', 'On Budget'))

A screen shoot or more details if possible

Thanks

[TauseefKhan · Accepted solution]

I Assuming you have already created variables vActual and vTarget using set analysis, they should look something like this:

// Set Analysis for Actual
 vActual = Sum({<SomeSetAnalysisConditions>} Actual);

// Set Analysis for Target
 vTarget = Sum({<SomeSetAnalysisConditions>} Target);

Add 'Company' as the dimension.

• Add two measures for the histogram:

• First measure for Actual: =$(vActual)

• Second measure for Target: =$(vTarget)