Partion with Offset

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

0 0 123
0 REPLIES 0
Top Labels in this Space
Top Solution Authors