Status history - additional information

Grafana
,
1

Hello all,
I’m searching for a solution to create a additional tooltip in a Status history graph.
I don’t think there is one, but maybe someone has an idea. :wink:

A query has the following result…
a time, a business service, a target level and a downtime

image
image818×329 22.5 KB

here a data example to play with…
“time”,“business_service”,“Min_target_level”,“Max_app_downtime”
2024-09-01 02:00:00,A,met,0
2024-10-01 02:00:00,A,met,0
2024-11-01 01:00:00,A,met,0
2024-12-01 01:00:00,A,met,0
2025-01-01 01:00:00,A,met,0
2025-02-01 01:00:00,A,met,0
2024-09-01 02:00:00,B,met,0
2024-10-01 02:00:00,B,met,0
2024-11-01 01:00:00,B,met,0
2024-12-01 01:00:00,B,met,0
2025-01-01 01:00:00,B,met,0
2025-02-01 01:00:00,B,met,0
2024-10-01 02:00:00,C,met,0
2024-11-01 01:00:00,C,met,0
2024-12-01 01:00:00,C,met,0
2025-01-01 01:00:00,C,met,0
2025-02-01 01:00:00,C,met,0
2024-09-01 02:00:00,D,met,0
2024-10-01 02:00:00,D,met,0
2024-11-01 01:00:00,D,met,0
2024-12-01 01:00:00,D,met,0
2025-01-01 01:00:00,D,met,0
2025-02-01 01:00:00,D,met,0
2024-10-01 02:00:00,E,met,0
2024-11-01 01:00:00,E,met,0
2024-12-01 01:00:00,E,met,0
2025-01-01 01:00:00,E,met,0
2025-02-01 01:00:00,E,met,0
2024-09-01 02:00:00,F,met,0
2024-10-01 02:00:00,F,met,0
2024-11-01 01:00:00,F,met,0
2024-12-01 01:00:00,F,met,0
2025-01-01 01:00:00,F,met,0
2025-02-01 01:00:00,F,met,0
2024-09-01 02:00:00,G,met,0
2024-10-01 02:00:00,G,met,0
2024-11-01 01:00:00,G,met,0
2024-12-01 01:00:00,G,missed,15000
2025-01-01 01:00:00,G,met,0
2025-02-01 01:00:00,G,met,0
2024-09-01 02:00:00,H,met,0
2024-10-01 02:00:00,H,met,0
2024-11-01 01:00:00,H,met,0
2024-12-01 01:00:00,H,met,0
2025-01-01 01:00:00,H,met,0
2025-02-01 01:00:00,H,met,0
2024-09-01 02:00:00,I,met,0
2024-10-01 02:00:00,I,met,0
2024-11-01 01:00:00,I,met,0
2024-12-01 01:00:00,I,met,0
2025-01-01 01:00:00,I,met,0
2025-02-01 01:00:00,I,met,0
2024-10-01 02:00:00,J,met,0
2024-11-01 01:00:00,J,met,0
2024-12-01 01:00:00,J,met,0
2025-01-01 01:00:00,J,met,0
2025-02-01 01:00:00,J,met,0
2024-09-01 02:00:00,K,met,0
2024-10-01 02:00:00,K,met,0
2024-11-01 01:00:00,K,met,0
2024-12-01 01:00:00,K,met,0
2025-01-01 01:00:00,K,met,0
2025-02-01 01:00:00,K,met,0
2024-09-01 02:00:00,L,met,0
2024-10-01 02:00:00,L,met,0
2024-11-01 01:00:00,L,met,0
2024-12-01 01:00:00,L,met,0
2025-01-01 01:00:00,L,met,0
2025-02-01 01:00:00,L,met,0
2024-09-01 02:00:00,M,met,0
2024-10-01 02:00:00,M,met,0
2024-11-01 01:00:00,M,met,0
2024-12-01 01:00:00,M,met,0
2025-01-01 01:00:00,M,missed,36000
2025-02-01 01:00:00,M,met,0
2024-09-01 02:00:00,N,met,0
2024-10-01 02:00:00,N,met,0
2024-11-01 01:00:00,N,missed,45900
2024-12-01 01:00:00,N,met,0
2025-01-01 01:00:00,N,met,0
2025-02-01 01:00:00,N,met,0
2024-09-01 02:00:00,O,met,0
2024-10-01 02:00:00,O,met,0
2024-11-01 01:00:00,O,met,0
2024-12-01 01:00:00,O,met,0
2025-01-01 01:00:00,O,met,0
2025-02-01 01:00:00,O,met,0
2024-09-01 02:00:00,P,met,0
2024-10-01 02:00:00,P,met,0
2024-11-01 01:00:00,P,met,0
2024-12-01 01:00:00,P,met,0
2025-01-01 01:00:00,P,met,0
2025-02-01 01:00:00,P,met,0
2024-09-01 02:00:00,Q,met,0
2024-10-01 02:00:00,Q,met,0
2024-11-01 01:00:00,Q,met,0
2024-12-01 01:00:00,Q,met,0
2025-01-01 01:00:00,Q,met,0
2025-02-01 01:00:00,Q,met,0
2024-09-01 02:00:00,R,met,0
2024-10-01 02:00:00,R,met,0
2024-11-01 01:00:00,R,met,0
2024-12-01 01:00:00,R,met,0
2025-01-01 01:00:00,R,met,0
2025-02-01 01:00:00,R,met,0

now I group it to matrix and change the time field

image
image943×177 16.4 KB

and with a little bit of value mapping I get… (as status history)

image
image1289×486 27 KB

The challenge is to display the downtime as additional tooltip for the missed fields.

image
image480×240 10 KB

I searched for a solution in ECharts…didn’t find one - any ideas?

Jo

2

Maybe business text using bootstrap table and tooltips

3

“Bootstrap”… wow the next strange thing I have to learn… :wink:

1 Like
4

can you try a data link with the title being the data?

that way when you hover over the data the data link title will pop up, sort of like a tooltip…

5

Could you maybe concat that values as html and tooltips might show it

but it messes things up

image
image402×330 17 KB

6

Josiah puts me on the right track to concat the values…
At the end it was the easiest way to combine the information I want to show.
I comma separated the two values in one field and split it again with value mapping.
So I can show the additional information in the table immediately.

image
image336×139 5.55 KB

thanks to all for the ideas.
Jo

1 Like