How do I transform values?

I’m running grafana with an influxdb database. Through telegraf, I am retrieving health stats from the fitbit development console.

I would like to create a simple graph which includes weight data, however fitbit store these values in lbs.

Is there a simple way for me to transform the lbs values and show them as kgs in a graph?

TIA.

Influx queries support simple math like what you need here. So you could for example add *0.454 to your SELECT statement.

Thank you so much for your help, @svetb!