Knowledge Drop

YTD, MTD Comparison

  • 5 April 2021
  • 0 replies
  • 413 views

Userlevel 5

Last Tested: Sep 21, 2018

 

This assumes date dimensions already exist in view.

Essentially, you'll want to create a yesno dimension that returns YES if date is before today

MTD Comparison (MySQL):

dimension: is_before_mtd {
type: yesno
sql: EXTRACT(Month from ${date_date}) < EXTRACT(Month from CURRENT_DATE);;
}

 

YTD Comparison (MySQL):

dimension: is_before_ytd {
type: yesno
sql: DAYOFYEAR(${date_date}) < DAYOFYEAR(CURRENT_DATE);;
}

 

This will return YES when dates are before the current date.

You can then filter on the YES to do analysis. Make sure to include the month timeframe!

Same concept can be carried out for YTD comparison. For more information check out this community article!

 

This content is subject to limited support.                

 

 


0 replies

Be the first to reply!

Reply