Convert string to integer


I use Influxdb database. I want to know if it’s possible to convert specific string to integer in grafana graph.

For exemple I need to know the status of my Apache server. In my influxdb database, we have for exemple “Apache service is working” or “Apache service is inactive”. The first data will return 1 and the last data will return 0. And with that I can make a graph.

How I can obtain this result ?


Any feature to do that ?