I want to use Looker-Viz to create Sales yesterday column and want to partition it on product type.
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.