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 NULL value in it?
Date |
---|
4/01/2020 |
7/01/2020 |
10/01/2020 |
1/01/2021 |