Combine timeseries with constant coming from json data

Grafana InfluxDB
1

  • What Grafana version and what operating system are you using? Linux open source grafana v10

  • What are you trying to achieve?
    Combine two datasources: influxdb and infinitive plugin - json data

  • How are you trying to achieve it?
    No idea what would be the best approach

  • What did you expect to happen?
    Timeseries data multiplicated by constant from json

Json (infinitive plugin to datasource json from http):
{ flats: [
{flatname : flat01, flatsize : 123},
{flatname : flat02, flatsize : 456}]
}

Expected result:
influxdb query timeseries multiplicated by 123

This is my intention how to multiply timeseries with a variable (constant per each flat) coming from json. Is this a good approach to do so or would you rather suggest a completely different solution how to accomplish such a task?

Thanks a lot

2

Ok, to me it seems that Variables-Constant is the easiest way to achieve this. Thus I made a flat01:123 Variable Constant, then an influxdb query with multiplication ${flat01} which is translated to multiplication of 123.