strings in Data source/data point?
Hello
We have some data that is held in a SQL server database table that we would like to use in a dashboard. Ideally the same
data set would populate a pie chart and a small table. ...
Forum Discussion
At the top of the linked page is this link to an example groovy script for MS SQL: https://github.com/sweenig/monitoring-recipes/blob/master/DataSources/Groovy/JDBC/Groovy_JDBC_MSSQL.groovy.
Line 38 has your SQL query, and lines 39-43 are where you'd have to write code to output the numbers based on the text values.
