Question

Partion with Offset

  • 24 December 2021
  • 0 replies
  • 41 views

Hi Team,
I want to use Looker-Viz to create Sales yesterday column and want to partition it on product type.
Eg.

Date.(dd/mm/yyyy) Type.          Sales     YesterdaySales

1/1/21 - Furniture   100.         NULL

2/1/21 - Furniture   300.         100

3/1/21 - Furniture   600.         300

1/1/21 - IT                 100.         NULL

2/1/21 - IT                  700.         100

I can do it via SQL but wanted to see if there is option to do it via Looker visualisation.

Thanks


This topic has been closed for comments