Select date in between

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:

  1. I want to choose with a filter for a specific day past or in the future, exp: 2022-07-19 how many subscriptions where active on this selected day. From our example: 3 are active
  1. How to compare each month of how many subscriptions we had compared to all the other months this also could be fixed to a specific date, also selected by product.

Thank you so much for any help!

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