Hello,
I need to visualize the history of the following state machine:
I had the idea to use the statusmap plugin but the timeline is wrong:
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.
https://localhost:3000/t/anyway-to-show-line-enable-disable-data-draw-in-any-plugin/25019
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.
