Calculate YOY , QOQ, MOM Calculations To Date.
Introduction
Quick functions are a great way to perform comparative analysis based on time periods. However there is no easy way to do a comparison to date. e.g. YTD vs YTD Last Year. e.g. If today is Sep 27, 2018 then we want to compare Jan 01 - Sept 27, 2018 to Jan 01 - Sept 27, 2017
Instructions
Add the following custom column in your Elasticube. e.g. YTD Flag
CASE
WHEN DayOfYear([Date Field]) <= Dayofyear(NOW()) THEN 'Y'
ELSE 'N'
ENDUse the Quick Functions as you would normally do, but this time add a filter for the YTD Flag and set the value to Y.
Updated 03-02-2023
