Expand Bar width (Grafana - MySQL)

Dear,

Basically this post contains two questions and the data contains the status per minute(unixtime0 of a machine:

  1. I am using a MariaDB server, similar to MySQL, and I’ve created a multi bar graph to show the availability of the machine. However, the width of the bar is too small. I’ve searched for solutions already and know that it is the result of the chosen time interval. But I do not found myself capable enough to implement the solutions.

  2. Furthermore, the actual result I want is an availability bar, with next to it a stacked bar of “Productive” and “Standby”. I want to group them by day to show how the availability is compiled of productive and standby.

Could anyone help me out? I am a bit of a beginner on Grafana.

\

my sql query looks like this:

SELECT
Timestamp/1000 AS “time”,
avg(MSD.Available) as “Availability”,
avg(MSD.Productive) as “Productive”,
avg(MSD.Standby) as “Standby”,
avg(MSD.UnscheduledDown) as “UnscheduledDown”,
avg(MSD.ScheduledDown) as “Scheduled Down”
FROM Availability as Av, MachineStatusDefinition as MSD
Where Av.idStatus = MSD.idStatus and Av.idMachineAllocation in ($Machine)
Group by DATE(FROM_UNIXTIME((TIMESTAMP/1000)))

this pluging isnt the answer, but may be is an altertative.

I don’t see how this could function as an alternative?

With this panel you can display the status of your machines without any problem… And it can aggregate the data, ex calculate total standby time.

In other hand, I think that you can have wider bars if you truncate de time column

But the timecolumn is necessary to display the timeseries graph

Edit:

I’ve got the bars thicker, by replacing Timestamp/1000 with date(From_unixtime(TIMESTAMP/1000))