Hey everyone.
I’ve got a problem I am trying to solve for a while now.
I have the following data:
Tags: use_case, language
Fields: iterations
Measurement 1: use_case - UC_1, language - English, iterations - 10
Measurement 2: use_case - UC_2, language - English, iterations - 5
Measurement 3: use_case - UC_1, language - French, iterations - 15
Measurement 4: use_case - UC_2, language - French, iterations - 3
I want to create a table with the following output:
use_case | iterations_English | iterations_French
UC1 | 10 | 15
UC2 | 5 | 3
I know I can create a table with four lines if I group by both language and use_case, but that’s not what I desire.
I am not sure if it’s possible to do so, so I’d appreciate getting help, or let me know if it’s even possible in the first place.
I’m not even sure how to define it in a few words, so I apologize if I posted in the wrong place, or gave a misleading name.
I found some answers online, but they don’t seem to work for me, probably because the InfluxDB we are using is outdated. I’d like to see if there’s a solution before I try to request an upgrade.
Thank you very much!