I have created a chart that is base on launch day and I want to count the number of IDs per each date in the chart but only if the ID has last_seen date that is >= from the day on the chart.
And this the chart with only count unique IDs without the condition.
Is this possible?
Another way (if I'm understanding correctly) would be to add a "helper column" at the data model level
Custom column would be:
CASE WHEN DATE_TRUNC(last_seen, DAY) >= DATE_TRUNC(launch_time) THEN 1
Then you can filter your unique count by that field (and only include those with a value of 1)