Line and bar chart in one with multiple axis legends

Grafana Stat Panel
1

Hello,

how can i define for each Metric a axis? I have temperature (Celsius), status off a device (on/off) and a consumption (kwh).

image
image1988×1158 155 KB

Thanks for your help - i am a rookie :slight_smile:

2

Just use the Query Transform and Organise Fields You might have.

3

thanks - do you have an example for me :innocent:

4

When you edit any panel you get the Query, Transform and Alert options as shown below

image

Selecting the Transform option you get Organize fields as shown below. Note the Merge option just above this!

image
image1213×436 30 KB

Then select Organize fields a shown below. Here I get a warning as I use several queries which need to first be merged into a single query before you may organize. I assume you only have a single query

image

Otherwise, you will get as shown below. Now you may rename and reorganize the order of any query variables as you desire.

image
image757×551 33.5 KB

Hope this helps.

If you have several queries then use the Transform option Merge and it will merge all queries into a single table all with a common timeline. Once you have done this you may then use Organize.

1 Like
5

Many thanks :slight_smile: Thats it

6

To Merge a JSON Querie sounds a little bit difficult. But i will see

7

Grafana does it for you! Just select merge and it will merge your queries.