How does the retention function calculate retention for multiple dates?

[zhangmingchao]

SELECT uid, retention(date = '2020-01-01', date = '2020-01-02', date = '2020-01-03') AS r FROM retention_test WHERE date IN ('2020-01-01', '2020-01-02', '2020-01-03') GROUP BY uid ORDER BY uid ASC
This sql only calculates the last two days of retention on the day of 2020-01-01, if you also want to calculate the last two days of retention on 2020-01-02?

SELECT uid, retention(date = '2020-01-01', date = '2020-01-02', date = '2020-01-03') AS r, retention(date = '2020-01-02', date = '2020-01-03', date = '2020-01-04') AS r2 FROM retention_test WHERE date IN ('2020-01-01', '2020-01-02', '2020-01-03') GROUP BY uid ORDER BY uid ASC
Do that?
Is there another way? I appreciate it very much!!!

[yariks5s]

Hi, @zhangmingchao! According to docs, there is only a possibility to compare the first argument with the others for retention function. So, if you want to set another start date for retention, you need to write one more function with this start date as the first argument. 🙂

[yariks5s]

If you have any further question, I can reopen this issue and we can discuss it here