Display only unique in table

Grafana
1

Hello, I have small problem with my report in grafana. Currently report display values from all queries in one column, hence I have multiple duplicates. Usually I export data into excel and display only unique values, but it always take me a time. I am wondering how I can display only unique values in grafana.

Data looks like in example below:

abc
abc
abc
asd
xyz
xyz
qwe
qaz
qaz

I want to display only unique values, and in case when value are duplicates then don’t display.
asd
qwe
…

Thanks for support.

2

it’s ugly i know…

image
image1151×1032 48.7 KB

  1. partition the unique values
  2. add the row index, rows with only a single result will only have a 0 index
  3. look for the max values only, duplicates will have an index greater than 0
  4. include only the results with a 0 row index, as they are the unique values
  5. rename the column
  6. you can remove the " Row" using a regex value mapping
3

What is your datasource? MySQL postgres? Mssql?