Querying in Athena

I need to know the revenue till today. How can I ask Athena?

1 Like

Hello, @keerthana.kalimuthu, there are two ways to accomplish this task. Firstly, you can mention the start and end date in the query itself, for instance, Revenue between 01/01/2023 and 24/03/2023. Secondly, if you want it to be done dynamically, you can use YTD revenue which stands for year-to-date revenue. Athena will calculate revenue aggregation from the beginning of the year until today. Additionally, you have the option to inquire about YTD revenue for last year, which will compute the revenue from the beginning of the year until today’s date for the previous year.