How to pick out a number from filterpane and connect it to a function for charts? getfieldselection() or getselectedcount()

[nezuko_kamado]

I created two graphs with,

Count({$<Weekly_Hours={">60"}>} distinct ID)

Count({$<Weekly_Hours={">40"}>} distinct ID)

But want display above in one graph by linking  filterpane number and getfieldselection() or getselectedcount() 

I tried

Count({$<Weekly_Hours> ={">"}+ getselectedcount(WeeklyHourSum)>}  distinct ID)

Count({$<Weekly_Hours= '>' & getselectedcount(WeeklyHourSum)>} distinct ID)

Count({$<Weekly_Hours={">"} + GetFieldSelections(WeeklyHourSum)>} distinct [Personnel Number])

Count({$<Weekly_Hours={ ">" & getselectedcount(WeeklyHourSum)}>} distinct [Personnel Number])

None of them work...  😞

[abhijitnalekar · Accepted solution]

Hi @nezuko_kamado ,

Please try below expression.

=Count({<Weekly_Hours={"$(='>='&GetFieldSelections(Weekly_Hours))"}>} distinct ID)