1

I'm developing an AWS timestream/Grafana dashboard, but I have some problems. I created the database and table in timestream and then in grafana I connected to the timestream datasource.

Now I want to do a dashboard with queries or transformations to display a formula; in my database, I have 2 measures "A" and "B", and I want to display the result of the following: (Dif(A) / Dif(B));

I read the documents but I didn't succeed at doing that.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
jackie
  • 39
  • 5
  • Thank you for your answer!! Dif means difference (Last-First), I achieved that. Is there a way to get the duration? I want the duration of a record when it was equal to 1. – jackie Apr 23 '21 at 10:32
  • Is there an "A" and "B" for each timestamp, or do they come in at different intervals? Are you trying to calculate (A_last_timestamp - A_first_timesamp) / (B_last_timestamp - B_first_timestamp)? – Duncan Drennan May 02 '21 at 22:38

1 Answers1

2

Do the two measures A and B have events with the same timestamp? What does Dif(A) mean? A sample query to get the result of A/B where every event of A and B have the same timestamp and is of type double is below

WITH cte1 AS (
    SELECT time, measure_value::double as value_a
    FROM <db>.<table>
    WHERE time > ago(1h) AND measure_name = 'A'
), cte2 AS (
    SELECT time, measure_value::double as value_b
    FROM <db>.<table>
    WHERE time > ago(1h) AND measure_name = 'B'
)
SELECT cte1.time, cte1.value_a / cte2.value_b
FROM cte1 INNER JOIN cte2 ON cte1.time = cte2.time
Rajesh Iyer
  • 41
  • 2