Is grafana storing all dashboard variables in string format ? I tried giving integer values using a MongoDB query using the data source option in variable. But it is being recognised as a string instead of an integer.
can you give more details on this?
Also you might want to explore the Convert field type
transformation: