Hi,
Cognite grafana plugin internally use synthetic timeseies api while passing query under “time series custom query” option. but synthetic timeseries api returns error while trying to retrieve data-point for string timeseries.
please check out attached screenshot.
Best answer by Dilesha Kodithuwakku
View originalHi Mitul,
The synthetic timeseries queries can not be used for string timeseries. If you want to handle it you need to convert string timeseries to double. For further information please refer to the documentation.
Best regards,
Dilesha
Hi Mitul,
I hope Dilesha’s answer helped. If not, please let us know!
When using synthetic time series you can do a mapping from string to a number to get out results, this might help your use case:
Map the strings OPEN → 1 and CLOSED → 0
map(TS{externalId='stringstate'}, ['OPEN', 'CLOSED'], [1, 0], -1)
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Check the
documentation
Ask the
Community
Take a look
at
Academy
Cognite
Status
Page
Contact
Cognite Support
