I'm trying to add a filter to a table so I can do something similar to the search function for numeric dimensions (where I can select to filter greater than x). I haven't been able to code the filter.

I want to be able to filter by Total or/and Total Canceladas >= x

-NOM_SOLI: "CL_Auto_Autorizaciones"."NOM_SOLI"

-Total: COUNT_TABLE("CL_Auto_Autorizaciones")

-Total Canceladas:

COUNT(DISTINCT

CASE WHEN PROCESS EQUALS 'Cancelada' THEN "CL_Auto_Autorizaciones"."_CASE_KEY"

ELSE NULL

END)

-Porcentaje Canceladas:

COUNT(DISTINCT

CASE WHEN PROCESS EQUALS 'Cancelada' THEN "CL_Auto_Autorizaciones"."_CASE_KEY"

ELSE NULL

END)/ COUNT_TABLE("CL_Auto_Autorizaciones")

"CL_Auto_Autorizaciones" is the case table