This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

How to calculate YTD,MTD ,LYYTD and Cumulative calculations in Looker?

Posted on 06-01-2021 12:22 AM
SureshBallem
New Member
Reply posted on --/--/---- --:-- AM

Hi All,

Could you please let me know How to calculate” YTD,MTD ,LYYTD and Cumulative “calculations in Looker?

Please provide a solutions ASAP it very urgent.

Regards,

Suresh

1 2 5,026
Topic Labels
2 REPLIES 2

Posted on --/--/---- --:-- AM
Dawid
Gold 2
Gold 2
Reply posted on --/--/---- --:-- AM

Looker doesn’t have any built-in solutions for that kind of comparison of timeframes. However, there have been few topics here in Community about this that you might found helpful.

https://community.looker.com/explores-36/special-date-filter-on-an-explore-24094https://community.looker.com/lookml-5/date-comparison-block-12198https://community.looker.com/lookml-5/period-over-period-and-ytd-mtd-19484

Posted on --/--/---- --:-- AM
salehaxsid
Silver 1
Silver 1
Reply posted on --/--/---- --:-- AM

There's no native functionality in looker related to period analysis or time intelligence function.
You can go through this approach that I tried for the same:
https://www.googlecloudcommunity.com/gc/Modeling/How-to-implement-DatesYTD-and-DatesMTD-using-LookML... 

0 Likes
Top Labels in this Space