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
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