If you are experiencing any formatting errors related to your dashboard variables, one of the best places to start troubleshooting is the query log. In the query log, you can view how Chartio translates your dashboard variable syntax into a SQL query, and how the query changes when specific values are selected.
For more information on accessing the query log, see our documentation query log documentation here.
To troubleshoot specific variable values used in a chart, use the Edit Variable Values option in the Data Explorer. This allows you to view how the query results change based on different variable values.