What is special query and where do we use it?
Hello, @anusha.venkatachalam. We have implemented specific functionalities that enable complex calculations through Athena. For instance, if you need to obtain the revenue accumulated until today, you can simply inquire about the “year to date revenue.” Similarly, if you wish to compare monthly revenue between two different years, you can inquire about the “compare revenue for this year and last year by month.”
1 Like