Old influx 1.8 query help w/ Grafana

I am new to both InfluxDB and its integration with Grafana and am on the struggle bus trying to get data to display in the way I want. I am unfortunately using older versions of influxdb (1.8) and Grafana (7.1) so not sure if upgrading will make my life easier.

I have data added to influxdb for performance testing results where we capture timings for each sub-step across builds and clients.

Example Data:

|| Step Name || Build || Avg Time(ms) ||
| Step1 | Build 1.1 | 500ms |
| Step1 | Build 1.2| 550ms |

Instead of having Step Names in repetitive sets using GroupBy I want to have a distinct Step Name and have the columns for the variable Builds names along with their respective Avg Time from the measurement.

Intended Data:

|| Step Name || Build 1.1|| Build 1.2 || Build 1.3||
| Step 1 | 500 ms | 550 ms | 495 ms |
| Step 2 | 610 ms| 590 ms | 394 ms |

Apologies if this is an easy question – I am new and learning.


Welcome to the forum.

Is this time series data? It appears to be a Step Name (string) followed by 3 “build time” values (integers). Maybe you can share the larger dataset that you are trying to query?

1 Like

It is a time series but we are using the timestamp in a somewhat odd fashion. We are using “export-csv-to-influx” python script to import CSV files generated from JMeter into InfluxDB. The timestamp is saving the CSV latest modified date (CSVs get deleted and re-added each run) so we store timestamp but care more about other metrics then timestamp.

Field Keys:

name: AverageStepTiming
fieldKey fieldType

AvgMs float
ProcessStepName string
Client string
branch string
commit string
timestamp string

name: AverageStepTiming


Current InfluxDB query:

Select (mean) as AvgMs from(SELECT mean("AvgMs") FROM "AverageStepTime" WHERE ("Client" =~ /^ClientName$/))  GROUP BY ProcessStepName, build

The above query gives me row over row of ProcessStepName for each build where-as I want the distinct ProcessStepName then the build variables in columns with their respective AvgMS value

Hello @jasong165,
Would using distinct() help?