Showing results for 
Search instead for 
Did you mean: 
Community Team Member
Community Team Member
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
WHEN DayOfYear([Date Field]) <= Dayofyear(NOW()) THEN 'Y'
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. 
Version history
Last update:
‎03-02-2023 08:36 AM
Updated by:
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email [email protected]

Share this page: