We have metrics in prometheus that have label values of ‘ABC123’, ‘ABC234’, ABCDEF’ which we want to convert to nice names such as ‘Foo’, ‘Bar’, ‘Baz’. We use the label_values function to create a variable and then another variable that sends the list to a simple json datasource that returns the nice names - and this works for one level - but we run into challenges if we chain them - selecting ‘Foo’ from that variable doesnt set ABC123 in the original - and we built a further reverse lookup to get back - but then started running onto an issue where rather than a list of values we only get the first one passed to the next variable …
Also we have to save the original variable with a default of All to get the first translation to drop down all the nice names.
Ideally i was after a simple ‘VLOOKUP’ like excel function for menus and for panel names etc.
We looked at the sql datasource that seems to have a value and text but i dont think it will do much more than we have right now as the origin of the data if the prometheus label values.
Have we missed a trick?