Special Query#

Special Query refer to a query that performs a specific or complex task beyond a simple SELECT query statement. There are various special query in our platform which retrieves a complex query with a simple word or short forms .The special query is given to Athena to obtain the insights

Here are some examples of Special Queries:

Query

Description

YTD

YTD stands for Year to Date and it indicates the time period starting from the beginning of the current year up to the present day which shows how the graph has changed over a time period. For example, to retrieve data from previous year or any other year, it is necessary to include the time frame to avoid misunderstandings and confusions.
For example : YTD revenue

If today is “March 24th then YTD command would retrieve the revenue data from the start of the year that is “January 1” till March 24th.

QTD

QTD stands for Quarter to Date and it indicates the time period starting from the current quarter up to present day. The quarter may differ based on their organization and the command works based on the quarter for that specific organization. To retrieve report or data from different Quarter of the year or month, it is necessary to include the time frame to avoid misunderstandings and confusions.
For example : QTD revenue by month

if the present day is March 24th, then the current quarter starts from January 1st, then the revenue data is retrieved from January 1st till March 24th by each month.

MTD

MTD stands for Month to Date and it indicates the time period starting from the current month up to present day. To retrieve report or data from different months of the year till date, it is necessary to include the time frame to avoid misunderstandings and confusions
For example : MTD revenue.

if today is March 24th, then the revenue data is retrieved from the current month starting March 1st up to the present date which is March 24th.

WTD

WTD stands for Week to Date and it represents the time period starting from the current week up to present day. To retrieve report or data from different week of the year till date, it is necessary to include the time frame to avoid misunderstandings.
For example : WTD revenue by day

if the present day is March 24th which is Friday, then the start of week would be Monday. The data would be retrieved from March 20th up to the present day which is March 24th by day

YOY

YOY stands for Year over Year. This command compares the difference between a year with the previous year of all the years present in the database. If data has to be retrieved on a specific year, then time frame can be used for the data extraction of the specific year.
For example : YOY revenue

This command retrieves the data for all year with the column showing the difference between year over the previous year.

QOQ

QOQ stands for Quarter over Quarter. This command compares the difference between a quarter with the previous quarter and displays the difference as QOQ column and it also displays the difference of the quarters present in all the years of the database. If data must be retrieved on a specific quarter, then time frame can be used for the data extraction of that specific quarter.
For example : QOQ revenue
This command retrieves the data of all the quarters with a QOQ column showing the difference between the quarter and the previous quarter present in all the years of the database till present day.

MOM

MOM stands for Month over Month. This command compares the difference between a month with the previous month and displays the difference as MOM column and it also displays the difference of the months present in all the years of the database. If data must be retrieved on a specific month, then time frame can be used for the data extraction of that specific month.
For example : MOM revenue

This command retrieves the data of all the months with a MOM column showing the difference between the month and the previous month present in all the years of the database till present day.

WOW

WOW stands for Week over Week. This command compares the difference between a week with the previous week and displays the difference as WOW column and it also displays the difference of the weeks present in all the years of the database. If data must be retrieved on a specific week, then time frame can be used for the data extraction of that specific week.
For example : WOW revenue
This command retrieves the data of all the week with a WOW column showing the difference between the week and the previous week present in all the years of the database till present day.

Compare

Compare query is a special query which is not a standard function but a customized query for the users. Compare is typically used to compare two values and return values based on their relationship. Compare function is used to compare data within the table.
For example : compare last year revenue with this year revenue by month

This query compares the revenue of the last year with the current year by month and displays the difference between then as separate column.

Top

Top query is a special query which is followed by “n” where n can be any number. It retrieves the data based on the default metric set by the users. User has the privilege to set the default metric in the configure SME and there can be more than one default metric
For example : “Top 10 products “

This query retrieves the top 10 products based on the revenue where revenue can be the default metric.

per

per command retrieves the data on an overall average basis
For example : Revenue per customer

This query retrieves the average of the customers revenue.

Trending

Trending query is a special query which retrieves the trending data based on current trend on the default metric set by the users. User has the privilege to set the default metric in the configure SME and there can be more than one default metric
For example : “Top 10 trending orders by revenue”
This query retrieves the top 10 trending orders based on the revenue where revenue can be the default metric.