Recommendation for displaying state machines

Hello,
I need to visualize the history of the following state machine:
Screenshot from 2020-01-21 16-23-27
I had the idea to use the statusmap plugin but the timeline is wrong:

grafana live:
http://xlnx-fae-srv-ldap.westeurope.cloudapp.azure.com:3001/d/7z2yjVsWz/public-dashboard?orgId=2&refresh=5s&from=now-24h&to=now

The State Timeseries is correct (times):

Has somebody an idea what plugin might be more suitable?

The data source is a mysql table:

CREATE TABLE status (Time DATETIME, state int, transition int, state_name varchar(255));

Thanks
Marco

Hi @marcoavnet can you tell me are you using statemap plugin to draw stongwan state. Would you like to answer this one.

I have a similar use case and i have shared the no of columns would you like to give me instructions to draw statemap bar chart for mentioned use case. Thanks

@marcoavnet Can you please give me reply on it.

Yes I use the statusmap plugin together with an SQL database.

Hi @marcoavnet Can you share sql query which you have used to plot this visualization and visualization style settings.

Of course:
SELECT

FLOOR(UNIX_TIMESTAMP(Time)) as time_sec,
state AS “stongswan state”
FROM status
WHERE
$__timeFilter(Time)
ORDER BY Time

SELECT
FLOOR(UNIX_TIMESTAMP(Time)) as time_sec,
transition AS “Strongswan transitions”
FROM status
WHERE
$__timeFilter(Time)
ORDER BY Time

Thanks @marcoavnet for sharing i will try to work on it and will let you know if i need any further investigation or help.