Time Relative Prefix operators analyze the performance of Metrics/KPIs over a period of time, like YOY (year on year), QOQ (Quarter on quarter), or MOM (Month on month). There are three types of time-relative prefix operators and they are:

This operator shows the change in the KPI/metric’s performance from a-time frame to its immediate previous time frame.

For example, if you need to see the "Change in Spend year by year, you will type in three keywords as follows:

'Change in' 'Spend' 'Yearly' - See the Image below

In the above example you can see the - Spend value in 2022 was ~USD 795,120, in 2023 was ~USD -266,558, and the change spend in 2024 is˜ USD -580,000.

Similar to the Çhange In' Operator, the '% change in' operator shows a Metrics performance from one time frame to its immediate previous time frame in a percentage value form.

For example, if you need to see the ”Percentage change in Spend monthly”. This will show the percentage change in Spending on a monthly basis as compared to the previous month. As shown in the image below.

This operator gives the absolute value change and percentage value change of the metric compared in the two-time frames.

For Example, you want to see the ”Absolute Value and Percentage Change in Spend Monthly”. Along with the Percentage Change and absolute change in the value, it also shows the Spend value for the current month and for the previous month.

With this operator, you can compare the performance of any metric with its past performances to assess the success or failure of any business strategy. For most values, a depreciation in value is a bad sign, while an appreciation in the value is good.

Some more examples of this type of operator are:

Read next: