Hi
I am running Grafana 7.5.4
I have a mysql table which has time in unixtime milliseconds and values that I would like to graph on a table with the call type.
We would like to see how many calls in a selectable timeframe and the type of call (call_type)
the table looks as follows
mysql> select * from voip_calls limit 1\G
*************************** 1. row ***************************
voip_call_id: ADEtiFrtdnsjks543
call_type: audio
call_started_timestamp: 1601282548609
call_ended_timestamp: 1601282612693
caller_user_id: 1234567
I have the following but it is not working:
SELECT
$__unixEpochGroupAlias(call_started_timestamp,$__interval),
call_type
FROM voip_calls
GROUP BY 1