Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am using a gauge in one of my dashboards with 3 colors red, green and yellow, and i am trying to get a condition where if i don't select any filters then the gauge operates according to one condition but if i select a filter then it operates according to that.
I am currently hard-coding the color gradient values because I cant find any other option, but because of that when i select any filters the gauge shows really low values.
Is there a way to write a condition to check whether a filter is selected or not? I'd like to keep the values without any filters because they are going to remain fixed no matter how much data i add, but i also want the condition to change when i select a filter.
You can use the GetSelectedCount function to determine whether there are values selected in your filtered field
GetSelectedCount([Your Field Name]) > 0
would indicate that there is at least one value selected
hi marcus,
thanks for the solution. is there a simple way i can do this for multiple fields? i am thinking of using GetSelectedCount with nested if loops but that would be a very big and complicated command
is there any simple way or command that could help me detect which filter is being picked and then set values according to that?