By using AWS re:Post, you agree to the Terms of Use

Athena + CUR report in Grafana - How to calculate relative time (last month)?

0

Stack - Managed Grafana + Athena and CUR as data.

I'm currently calculating my billing cost using $__timeFilter(line item usage start date) in my query. I'd like to compute the exact cost between the same days in the previous month as well. For example $__timeFilter(line item usage start date) output:

select SUM(line_item_blended_cost + discount_total_discount) from yad2_billing_reports where line_item_usage_start_date BETWEEN TIMESTAMP '2022-08-01 14:56:16' AND TIMESTAMP '2022-08-08 14:56:16'

I would like to get :

select SUM(line_item_blended_cost + discount_total_discount) from yad2_billing_reports where line_item_usage_start_date BETWEEN TIMESTAMP '2022-07-01 14:56:16' AND TIMESTAMP '2022-08-08 14:56:16'

2 Answers
1
Accepted Answer

I ended up using the query:

select SUM(line_item_blended_cost + discount_total_discount) as cost from $CUR_Table where line_item_usage_start_date > $__timeFrom() - interval '1' month and line_item_usage_start_date < $__timeTo() - interval '1' month

answered a month ago
0

Better to use $__timeFrom() and $__timeTo() as per your usecase

SUPPORT ENGINEER
answered a month ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions