Gauge Chart Limits,Max & Min Problem

[BouwerVa]

Hi I'm trying to set my gauge limit to the previous year's total. But my gauge is connected to Year Filter.

In other word when I select 2019. The pointer must be 2019 total. The limit must be 2018 total and max must be 2018 + 30%. But my Pointer and Limit keeps giving me the same value.

Here is my Formula's:

Point : sum(if(TTYPE = 'Lo', CAPITAL))/1000000

Min: 0

Max : (sum({<Year={$(=max(Year)-1)},TTYPE={"Lo"}>}CAPITAL)*1.3)/1000000

Limit: sum({<Year={$(=max(Year)-1)},TTYPE={"Lo"}>}CAPITAL)/1000000

Results: The Limit and Point still gives the same value

[BouwerVa]

Hi I'm trying to set my gauge limit to the previous year's total. But my gauge is connected to Year Filter.

In other word when I select 2019. The pointer must be 2019 total. The limit must be 2018 total and max must be 2018 + 30%. But my Pointer and Limit keeps giving me the same value.

Here is my Formula's:

Point : sum(if(TTYPE = 'Lo', CAPITAL))/1000000

Min: 0

Max : (sum({<Year={$(=max(Year)-1)},TTYPE={"Lo"}>}CAPITAL)*1.3)/1000000

Limit: sum({<Year={$(=max(Year)-1)},TTYPE={"Lo"}>}CAPITAL)/1000000

Results: The Limit and Point still gives the same value

[lironbaram · Accepted solution]

hi 

the field you are making the selections is FIN_YEAR

as you are not referencing him in your expression your expression doesn't work 

maybe something like :

sum({<FIN_YEAR={$(=max(FIN_YEAR)-1)},TTYPE={"Lo"}>}CAPITAL)*1.3)/1000000

or 

sum({<FIN_YEAR=,Year={$(=max(Year)-1)},TTYPE={"Lo"}>}CAPITAL)*1.3)/1000000