Create LLY(last to last year) Sales Measure in Looker

  • 13 January 2021
  • 0 replies


I am trying to create LLY(last to last year) measure in Looker. At the moment I have sales for SLS TY (January 2021) and I add SLS LY (January 2020). If I pull in the measure SLS LLY in the look, I should get the sales for January 2019. I do not have the SLS LLY field in my snowflake database but I have the SLS TY and SLS LY.

I think this is a bit complicated, but any ideas would be appreciated.

0 replies

Be the first to reply!