Feature Request: Add a third Metric to Group Results and have seperate auto generated colours in the Graph

[Bubbu17]

I would like to have a third Metric to Group Results in the Graph by different colors and different labels which are shown in the Legend as well.

a snippet of data data source which are used, all data are written in a column a could only be separated by its unique ID Column, this would be the third metric I would prefer to use to Group the data.

This is how it looks like at the moment:

Below it is shown, that the curves have a different ID but are represented in the same color.


Below the section where the third Metric, in my Case ID, should also be defined as a grouping operator for the curves.

Regards Torsten

[Bubbu17]

Hello I tried it with Grafana 7.0.0 with the Standard Grafana Graf but i wasent able to achieve my goals like discribed above.

I was able to set up the graf and the proper legend but i am unable to show the caracteristic curves of the devices inside the graf.

[Bubbu17]

How can i use a non Timeseries X axis to print the graf anyway?

[Bubbu17]

Following sample data:

ID data time
May 13 2020 7:25AM 700005575319 -0.01922607 2
May 13 2020 7:28AM 700005575319 0.04119873 2
May 11 2020 7:58AM 700005575320 0.04943848 2
May 13 2020 7:31AM 700005575319 -0.0604248 2
May 13 2020 8:10AM 700005575319 -0.07141113 2
May 13 2020 7:34AM 700005575319 -0.09338379 2
May 15 2020 5:54AM 700005575319 0.1263428 2
May 11 2020 7:49AM 700005575318 0.1428223 2
May 13 2020 7:25AM 700005575319 0.002746582 3
May 13 2020 7:31AM 700005575319 -0.05493164 3
May 13 2020 7:28AM 700005575319 0.05767822 3
May 13 2020 8:10AM 700005575319 -0.0604248 3
May 11 2020 7:58AM 700005575320 0.07141113 3
May 13 2020 7:34AM 700005575319 -0.08239746 3
May 15 2020 5:54AM 700005575319 0.1318359 3
May 11 2020 7:49AM 700005575318 0.1538086 3
May 13 2020 7:25AM 700005575319 0.01373291 4
May 13 2020 7:31AM 700005575319 -0.04394531 4
May 13 2020 8:10AM 700005575319 -0.04943848 4
May 13 2020 7:34AM 700005575319 -0.06591797 4
May 13 2020 7:28AM 700005575319 0.06866455 4
May 11 2020 7:58AM 700005575320 0.09887695 4
May 15 2020 5:54AM 700005575319 0.1318359 4
May 11 2020 7:49AM 700005575318 0.1538086 4
May 13 2020 7:25AM 700005575319 0.03570557 5
May 13 2020 8:10AM 700005575319 -0.03845215 5
May 13 2020 7:31AM 700005575319 -0.04394531 5
May 13 2020 7:34AM 700005575319 -0.05493164 5
May 13 2020 7:28AM 700005575319 0.08514404 5
May 11 2020 7:58AM 700005575320 0.1098633 5
May 15 2020 5:54AM 700005575319 0.1428223 5
May 11 2020 7:49AM 700005575318 0.1593018 5
May 13 2020 8:10AM 700005575319 -0.02197266 6
May 13 2020 7:34AM 700005575319 -0.03295898 6
May 13 2020 7:31AM 700005575319 -0.04394531 6
May 13 2020 7:25AM 700005575319 0.05218506 6
May 13 2020 7:28AM 700005575319 0.09613037 6
May 11 2020 7:58AM 700005575320 0.1318359 6
May 15 2020 5:54AM 700005575319 0.1428223 6
May 11 2020 7:49AM 700005575318 0.1647949 6
May 13 2020 8:10AM 700005575319 -0.02197266 7
May 13 2020 7:34AM 700005575319 -0.03845215 7
May 13 2020 7:31AM 700005575319 -0.04943848 7
May 13 2020 7:25AM 700005575319 0.05767822 7
May 13 2020 7:28AM 700005575319 0.09063721 7
May 11 2020 7:58AM 700005575320 0.1318359 7
May 15 2020 5:54AM 700005575319 0.1318359 7
May 11 2020 7:49AM 700005575318 0.1538086 7
May 13 2020 8:10AM 700005575319 -0.01647949 8
May 13 2020 7:34AM 700005575319 -0.02746582 8
May 13 2020 7:31AM 700005575319 -0.03845215 8
May 13 2020 7:25AM 700005575319 0.06866455 8
May 13 2020 7:28AM 700005575319 0.09063721 8
May 15 2020 5:54AM 700005575319 0.1263428 8
May 11 2020 7:58AM 700005575320 0.1373291 8
May 11 2020 7:49AM 700005575318 0.1483154 8
May 13 2020 8:10AM 700005575319 -0.01647949 9
May 13 2020 7:34AM 700005575319 -0.02746582 9
May 13 2020 7:31AM 700005575319 -0.04394531 9
May 13 2020 7:25AM 700005575319 0.06866455 9
May 13 2020 7:28AM 700005575319 0.09063721 9
May 15 2020 5:54AM 700005575319 0.1098633 9
May 11 2020 7:49AM 700005575318 0.1318359 9
May 11 2020 7:58AM 700005575320 0.1428223 9
May 13 2020 8:10AM 700005575319 -0.01098633 10
May 13 2020 7:34AM 700005575319 -0.02746582 10
May 13 2020 7:31AM 700005575319 -0.03845215 10
May 13 2020 7:25AM 700005575319 0.06866455 10
May 13 2020 7:28AM 700005575319 0.09063721 10
May 15 2020 5:54AM 700005575319 0.09887695 10
May 11 2020 7:49AM 700005575318 0.1153564 10
May 11 2020 7:58AM 700005575320 0.1318359 10
May 13 2020 8:10AM 700005575319 -0.005493164 11
May 13 2020 7:34AM 700005575319 -0.02197266 11
May 13 2020 7:31AM 700005575319 -0.02746582 11
May 13 2020 7:25AM 700005575319 0.07965088 11
May 15 2020 5:54AM 700005575319 0.09338379 11
May 13 2020 7:28AM 700005575319 0.1016235 11
May 11 2020 7:49AM 700005575318 0.1153564 11
May 11 2020 7:58AM 700005575320 0.1318359 11
May 13 2020 8:10AM 700005575319 0.005493164 12
May 13 2020 7:34AM 700005575319 -0.01647949 12
May 13 2020 7:31AM 700005575319 -0.02197266 12
May 13 2020 7:25AM 700005575319 0.08514404 12
May 15 2020 5:54AM 700005575319 0.08789063 12
May 13 2020 7:28AM 700005575319 0.1071167 12
May 11 2020 7:49AM 700005575318 0.1098633 12
May 11 2020 7:58AM 700005575320 0.1318359 12
May 13 2020 8:10AM 700005575319 0.005493164 13
May 13 2020 7:31AM 700005575319 -0.01098633 13
May 13 2020 7:34AM 700005575319 -0.01647949 13
May 15 2020 5:54AM 700005575319 0.08239746 13
May 13 2020 7:25AM 700005575319 0.08514404 13
May 13 2020 7:28AM 700005575319 0.09613037 13
May 11 2020 7:49AM 700005575318 0.09887695 13
May 11 2020 7:58AM 700005575320 0.1318359 13
May 13 2020 7:31AM 700005575319 0 14
May 13 2020 7:34AM 700005575319 0 14
May 13 2020 8:10AM 700005575319 0.01647949 14
May 15 2020 5:54AM 700005575319 0.0769043 14
May 13 2020 7:25AM 700005575319 0.08514404 14
May 11 2020 7:49AM 700005575318 0.09887695 14
May 13 2020 7:28AM 700005575319 0.1071167 14
May 11 2020 7:58AM 700005575320 0.1318359 14
May 13 2020 7:34AM 700005575319 0 15
May 13 2020 7:31AM 700005575319 0.005493164 15
May 13 2020 8:10AM 700005575319 0.02197266 15
May 15 2020 5:54AM 700005575319 0.07141113 15
May 13 2020 7:25AM 700005575319 0.08514404 15
May 11 2020 7:49AM 700005575318 0.08789063 15
May 13 2020 7:28AM 700005575319 0.1126099 15
May 11 2020 7:58AM 700005575320 0.1373291 15
May 13 2020 7:34AM 700005575319 0.01098633 16
May 13 2020 7:31AM 700005575319 0.02197266 16
May 13 2020 8:10AM 700005575319 0.03295898 16
May 15 2020 5:54AM 700005575319 0.06591797 16
May 11 2020 7:49AM 700005575318 0.08239746 16
May 13 2020 7:25AM 700005575319 0.09063721 16
May 13 2020 7:28AM 700005575319 0.1290894 16
May 11 2020 7:58AM 700005575320 0.1538086 16
May 13 2020 7:31AM 700005575319 0.02746582 17
May 13 2020 7:34AM 700005575319 0.02746582 17
May 13 2020 8:10AM 700005575319 0.04943848 17
May 15 2020 5:54AM 700005575319 0.07141113 17
May 11 2020 7:49AM 700005575318 0.0769043 17
May 13 2020 7:25AM 700005575319 0.1071167 17
May 13 2020 7:28AM 700005575319 0.1345825 17
May 11 2020 7:58AM 700005575320 0.1757813 17
May 13 2020 7:31AM 700005575319 0.03295898 18
May 13 2020 7:34AM 700005575319 0.04394531 18
May 13 2020 8:10AM 700005575319 0.06591797 18
May 11 2020 7:49AM 700005575318 0.06591797 18
May 15 2020 5:54AM 700005575319 0.08239746 18
May 13 2020 7:25AM 700005575319 0.1290894 18
May 13 2020 7:28AM 700005575319 0.1455688 18
May 11 2020 7:58AM 700005575320 0.1922607 18

[Bubbu17]

similar to this #9 and this #102 issue

[Bubbu17]

like this