Year to Date Function

  • 9 August 2017
  • 2 replies


Does any of you know what is the best option to develop a YTD column in Looker considering that I have an explorer license and I am using functions ?

Thanks! 😃

2 replies

Hi @Gee_Ouu

You may want to consider using the following Discourse post Week-to-Date (WTD) Comparison as a reference on how to make a YTD field.

The thing to keep in mind is that your SQL dialect (Redshift, MySQL, Postgres, etc) will determine what syntax is used. Note there are some alternate syntax recommendations in the comments section of that article.

@Gee_Ouu I just realized that you may not have direct access to LookML, based on your initial message. You may consider providing the WTD example to your internal LookerDevelopment Team and they can build it out for you…

If you can only access the Explore UI, you can consider using Table Calculations; however, I can’t think of a direct example for YTD using Table Calculations. But using Table Calculations, in conjunction with pivoted fields may get you closer to your desired goal.