Hi,
I have seen a video on https://www.youtube.com/watch?v=I3o3tnj5j6s&feature=emb_logo, in which at 11:53 you can see the graph:
I have a dataset with columns:
datetime,
modem,
tap_id,
tap_val.
For example:
dtime |modem|tap_nr|tap_val|
-------------------|-----|------|-------|
2020-04-02 12:00:00|M1 |tap01 | 3|
2020-04-02 12:00:00|M1 |tap02 | 2|
2020-04-02 12:00:00|M1 |tap03 | 10|
2020-04-02 12:00:00|M1 |tap04 | 5|
2020-04-02 12:00:00|M1 |tap05 | 8|
2020-04-02 12:00:00|M1 |tap06 | 6|
2020-04-02 12:00:00|M1 |tap07 | 10|
2020-04-02 12:00:00|M1 |tap08 | 4|
2020-04-02 12:00:00|M1 |tap09 | 3|
2020-04-02 12:00:00|M1 |tap10 | 6|
2020-04-02 12:00:00|M2 |tap01 | 4|
2020-04-02 12:00:00|M2 |tap02 | 3|
2020-04-02 12:00:00|M2 |tap03 | 11|
2020-04-02 12:00:00|M2 |tap04 | 6|
2020-04-02 12:00:00|M2 |tap05 | 9|
2020-04-02 12:00:00|M2 |tap06 | 7|
2020-04-02 12:00:00|M2 |tap07 | 11|
2020-04-02 12:00:00|M2 |tap08 | 5|
2020-04-02 12:00:00|M2 |tap09 | 4|
2020-04-02 12:00:00|M2 |tap10 | 7|
2020-04-02 12:30:00|M1 |tap01 | 1|
2020-04-02 12:30:00|M1 |tap02 | 3|
2020-04-02 12:30:00|M1 |tap03 | 6|
2020-04-02 12:30:00|M1 |tap04 | 4|
2020-04-02 12:30:00|M1 |tap05 | 9|
2020-04-02 12:30:00|M1 |tap06 | 2|
2020-04-02 12:30:00|M1 |tap07 | 10|
2020-04-02 12:30:00|M1 |tap08 | 5|
2020-04-02 12:30:00|M1 |tap09 | 6|
2020-04-02 12:30:00|M1 |tap10 | 3|
2020-04-02 12:30:00|M2 |tap01 | 7|
2020-04-02 12:30:00|M2 |tap02 | 3|
2020-04-02 12:30:00|M2 |tap03 | 4|
2020-04-02 12:30:00|M2 |tap04 | 3|
2020-04-02 12:30:00|M2 |tap05 | 4|
2020-04-02 12:30:00|M2 |tap06 | 5|
2020-04-02 12:30:00|M2 |tap07 | 8|
2020-04-02 12:30:00|M2 |tap08 | 4|
2020-04-02 12:30:00|M2 |tap09 | 1|
2020-04-02 12:30:00|M2 |tap10 | 10|
Basically, we are monitoring modems through time, and log (every 30 min) their taps (tap = switch) positions (single modem usually have more taps and one tap can have position in range of integers).
Idea is to show line graph for certain 30 min for all modems in barchart or linechart format.
I have created such charts as toy example in python and plotly for barchart:
or linechart:
Can I somehow do this in Grafana?
According to the video from the beginning of this post, it is possible, but I don’t know how?
Can someone please help?
Regards.