Calculate YOY , QOQ, MOM Calculations To Date.

[intapiuser]

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'
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.