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
