I want to combine multiple time series data into one table to export it to a .csv file.
So far, I have tried in the influx web interface, to select 5 values I want to be combined into one .csv table. They are then all shown correctly in one graph, however, when I now press export as .csv, their tables are all listed as separate blocks beneath each other.
My goal is to archive one table including all 5 values and one row of timestamp, like this:
| _time | val_1 | val_2 | val_3 | val_4 | val_5
| "timestamp" | 1 | 2 | 0 | 1 | 3
| "timestamp" | 3 | 1 | 2 | 1 | 1
| "timestamp" | 2 | 1 | 0 | 1 | 2
How do I achieve this?