Conditional formula based on value from chart
Hi, 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. ...
Forum Discussion
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
ELSE 0
END
Then you can filter your unique count by that field (and only include those with a value of 1)
