# Community

Announcements
Highlighted
New Contributor II

## Gauge Chart Limits,Max & Min Problem

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

Labels (1)
• ### Gauge chart Limits

1 Solution

Accepted Solutions
Partner

## Re: Gauge Chart Limits,Max & Min Problem

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

Partner

## Re: Gauge Chart Limits,Max & Min Problem

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