Is it possible to draw a Horizontal table in Grafana?

1

I have DB as below

create table TestSuiteData1 (
testsuite_name VARCHAR(400) NOT NULL,
no_total_test INT NOT NULL,
no_test_passed INT NOT NULL,
no_test_failed INT NOT NULL,
no_test_skipped INT NOT NULL,
execution_date DATE
);

I want to draw table as below. If “no_test_failed” colounm value is ‘0’ I want that colounm should green else red.

TestSuiteGraph
TestSuiteGraph2592×1340 190 KB

I have data something like below

INSERT INTO TestSuiteData1 VALUES
(‘AD’,800,750,38,12,‘2018-02-19’),
(‘AWS’,500,500,0,0,‘2018-02-19’),
(‘JDBC’,43,43,0,0,‘2018-02-19’),
(‘OpenLDAP’,78,0,78,0,‘2018-02-19’),
(‘AD’,800,0,0,800,‘2018-02-20’),
(‘AWS’,534,0,0,0,‘2018-02-20’),
(‘JDBC’,4,0,0,0,‘2018-02-20’),
(‘OpenLDAP’,78,0,23,0,‘2018-02-20’),
(‘AD’,8,750,38,12,‘2018-02-21’),
(‘AWS’,5,54,456,34,‘2018-02-21’),
(‘JDBC’,4,43,5,56,‘2018-02-21’),
(‘OpenLDAP’,78,0,23,0,‘2018-02-21’);

2

@mefraimsson any thoughts regarding this ?

3

Hi,

Grafanas graph panel nor table panel don’t support such graph. Possible that someone in the community has created a panel plugin that supports this.

Maybe this issue is interesting for you: https://github.com/grafana/grafana/issues/7169

Marcus

1 Like
4

Thanks @mefraimsson sooner or letter I try to develop a plugin for horizontal planels.

5

I’m using discrete panel plugin to something similar: monitor whether our filter is “Filtering” , “Washing” ,“Closed”, etc…

I think that will help you.

1 Like