Forum Discussion

david_gray's avatar
3 years ago

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.  e.g. 

We have a data source using a JDBC connection over to the SQL server and that all works, problem is that the data point does not work with 

strings (in this case status).    

So my question is, how can I pull all seven columns in this data set to show in my dashboard?   Is there a way of doing this or 

is NAN (not a number) an insurmountable block? 

The data source is as follows: 

  

 

The error message is NAN (not a number)