I do something similar for regions in my data set. My SQL query includes a WHERE clause like so:
… AND application LIKE ‘BMSI_TAF_[[Region]]’ …
The dashboard defines the variables with a SELECT DISTINCT query on the data set to gather the possible values (e.g. BMSI_TAF_BC, BMSI_TAF_AB, etc.), and a regex to isolate the varying part of the value:
BMSI_TAF_([^,]*)
With this setup, the region variable contains values such as BC, AB, etc., and the queries respect the selected region.
Your regex might look something like:
application_get([^,]*)Count_total