Hi
We have subscriptions for our customers.
So the table would look like this example:
# Customer | Date Start | Date End | Product |
001 | 2019-05-04 | 9999-12-31 | A |
002 | 2014-06-30 | 2022-06-19 | B |
003 | 2020-05-01 | 2021-06-05 | A |
004 | 2022-02-01 | 9999-12-31 | A |
005 | 2022-08-01 | 9999-12-31 | C |
006 | 2021-02-03 | 2022-09-05 | C |
The date: 9999-12-31 means it has not been canceled yet, otherwise there would be a date.
The question I’ve no idea how looker could solve this:
Thank you so much for any help!