Polystat : transform data

Grafana Dashboards
1

Hello everyone, I’m facing some difficulties that are explained below. Thanks in advance for your help !

  • What Grafana version and what operating system are you using?
    → Grafana v11.2.0

  • What are you trying to achieve?
    → For the color of each hexagonal of the polystat visualization to depend on the state of an element which value is displayed.

  • How are you trying to achieve it?
    → I’m trying to use the “transform data” possibility by using each state as a unique value that act as a treshold for the element displayed. For this I’m searching for the last state value and testing if it’s equal to 0 (STATE0), if it’s equal to 1 (STATE1) or if it’s equal to 2 (STATE2).

  • What happened?
    → I can’t make those tresholds to be shown as the classic configuration of treshold takes advantage. If I delete the classic treshold then the polystat visualization has some kind of color base that we have to specify.

  • What did you expect to happen?
    → I expected the hexagon to take the color based on the actual state (STATE0, STATE1 or STATE2).

  • Can you copy/paste the configuration(s) that you are having problems with?

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
    → No errors.

  • Did you follow any online instructions? If so, what is the URL?
    → I didn’t.

You have reached the end of this explanation !

1 Like
2

did the standard threshholds not work for you?

image
image2125×540 136 KB

4

First of all thank you for responding !
I would like the treshold to be based on the state of the value I’m displaying. For example displaying the value of temperature and in my database in the table that contains this value there is also the state (like captor OK, captor BAD or captor PERFECT). These 3 possible states have a value (0,1,or 2) and I would like to use those values for the treshold of the displayed temperature

5

Unfortunately, it is not possible to use variables for the thresholds at the moment.

Is that what you mean?

Otherwise give us a specific example in a table form.

6

i think she wants the colour of the polygons to be based on the 3 states, and not the 3 different temperatures, i am a little busy to knock this up just now :slight_smile:

7

Actually I would like to use the state value for the thresholds and not the temperature value.

8

Yes, this is exactly the goal ! No worries to have, thank you for clearing the issue for everyone :slightly_smiling_face:

11

That is the issue I’m facing, I appreciate your answer.
What do you mean exactly by saying “field thresholds” ?
About the “Value mappings” I have tried it however it seemed like it wasn’t possible to use STATE0, STATE1 and STATE2 as it only allows values.

12

That plugin is a bit limited to do what you exactly want but look at this approach also as a possible solution.

13

I will definitely look into it, thank you for sharing ! If i get it well, the idea is to use JS in order to redo some kind of polystat and be able to specify the parameters, right ?

1 Like