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.
|| 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.
|| 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?
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.
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
Would using distinct() help?