Timestream + Grafana

Question

Today's build is a Grafana Dashboard which is pulling in live data from aws timestream.

Currently, it's showing line graphs which is broken down by hour. The query we use is this:

WITH binned_query AS (
    SELECT
        BIN(time,1h) AS "point",
        x_id  AS "series",
        max(measure_value::bigint) AS "metric"
    FROM $__database.$__table
    WHERE measure_name = 'x'
    AND $__timeFilter 
    GROUP BY BIN(time,1h), x_id order by 1
)
SELECT series, CREATE_TIME_SERIES(point,metric)
FROM binned_query 
GROUP BY series

With the above what is happening is that we are getting data points that are all 1 hour apart. Which is great for some date ranges like 24 hours or 2 days, but when you are looking at 1 hour it would be nice to have it show every minute or 10 minutes.

To accomplish this I see two potential solutions neither of which I've been successful in implementing:

Adjust the query to somehow consider the date-range and change the granularity of the data points.
Some way to add a drop down that would control the granularity of the graphs. This way we could select a date range (say a month) and then I can adjust the line graphs to show 1 min, 5 min, 15 min, 30 min, 1 hr, 3 hr, 6 hr, 12 hr, 24 hr, 48 hr

Any help would be greatly appreciated, been a frustrating morning trying to get this working :)

score 1 · Accepted Answer · answered Aug 18 '21 at 02:18

1

The $__interval variable might be more useful here instead of 1h.

This value will change based on the size of the graph/panel and time range. Alternatively if you wanted to keep it at 1h for all graphs and change as you see fit, you could still use this variable and set the interval manually in the panel settings.

answered Aug 18 '21 at 02:18

Kevin Minehart

482
4
14

This was a great suggestion! I tried it but unfortunately the plugin in grafana for timestream doesn't support the $__interval value yet. It only supports $__interval_ms and I can't get that to work with the BIN function. Have requested $__interval be added to the plugin. – nickCR Aug 19 '21 at 17:06

score 0 · Answer 2 · answered Jun 24 '22 at 03:34

The post is old, but just in case if someone has the same problem. For Grafana timestream it's possible to use your own variables. Go to a dashboard settings, and add a variable, like this one:

Then instead of using 1h, use $time_delta. The value can be chosen in the dashboard as a dropdown:

Timestream + Grafana

2 Answers2