Looking for Answers?
Browse our articles to find the answers you need
Calculate YOY , QOQ, MOM Calculations To Date.
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
Add the following custom column in your Elasticube. e.g. YTD Flag
1 2 3 4
CASE WHEN DayOfYear([Date Field]) <= Dayofyear(NOW()) THEN 'Y' ELSE 'N' END
Use the Quick Functions as you would normally do, but this time add a filter for the YTD Flag and set the value to Y.
Was this article helpful?