I have tabular data containing 3 fields: name, value and category.
I want to display this data using the table panel where the name is shown as text, the value shown as a gauge and the category is used to color the bars of the gauge.
I have control over the the specific category values and don’t want to show them explicitly so as a first step I replaced them by color names.
I then used a transform to try to apply the colors to the respective rows, but I only partially succeeded. It maps the actual numerical values to the colors and not the rows. This means that if I have 2 rows with the same value but a different category/color, they will show up as the same color.
Could someone point me in the right direction of how to do this properly?