Newbie trying to test run Graph mode and having issues

Grafana MSSQL
1

I’m giving Grafana a test run and i know i probably need to learn about sql queries :slight_smile: but i am having issues with a simple dbase table in MS sql and getting it to show up in grafana. I did follow the “time series query” example from /docs/grafana/v7.5/datasources/mssql/ and i got it plotting fine in an example table i setup. i’m just not sure how to go about getting my table going in Graphs or Heatmap or Bar Gauge ?? or what other visualization app would be best for my table layout/data, see below , any help appreciated… i assume i need to convert the object_status to numeric 1/0 somehow in the query then what visualization to choose in Grafana to best fit it ?

+----------------------+--------------+---------------+
| My_datetime          | Object_type  | Object_status |
+----------------------+--------------+---------------+
| 2020-04-02 15:55:00  | Object1      | OFFLINE       |
| 2020-04-02 16:02:00  | Object2      | OFFLINE       |
| 2020-04-02 16:05:00  | Object1      | ONLINE        |
| 2020-04-02 16:07:00  | Object3      | OFFLINE       |
| 2020-04-02 16:10:00  | Object2      | ONLINE        |
| 2020-04-02 16:13:00  | Object3      | ONLINE        |
+----------------------+--------------+---------------+
2

so i fig it out

SELECT
  $__timeEpoch(my_datetime),
  case
        when object_status = 'OFFLINE' then 0
        when object_status = 'ONLINE' then 1
    end as value,
  object_type as metric
FROM
  my_table
WHERE
  $__timeFilter(my_datetime)
ORDER BY
  my_datetime ASC