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
Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.
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,045
Topic Labels
Reply
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
Reply

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
Reply
Top Labels in this Space