We have only one date column in database but two different references (alias in SQL) need to be made out of them (current and previous) to proceed further and compare as per requirement. How to achieve this LookML?And how to deal with date field with...

Please help me understand converting some SQL query (see demo example below) into equivalent LookML coding; explaining whether dimension/measures/views to achieve same data table structure in Looker/LookML.SELECT order_date, status, SUM(variableA) re...

Price Count Total Price Product A 1 2 3 Product B 1 2 3 Subtotal A+B A1+B1 A2+B2 A3+B3 Product C 1 2 3 Product D 1 2 3 Subtotal C+D C1+D1 C2+D2 C3+D3 Product E 1 2 3 Product F 1 2 3 Subtotal E+F E1+F1 E2+F2 E3+F3 How to achieve this above kind of sub...