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.
And this the chart with only count unique IDs without the condition.
Is this possible?
Something like this maybe? For each ID on that launch_date, if last_seen is before or same as launch_date then include the ID in a unique count.
COUNT ( [ID] ,
IF (
MIN ( DDIFF ( [Days in last_seen] , [Days in launch_date] ) ) <= 0
, [Max ID]
, NULL
)
)
My issue is actually different then I mistakenly described. Created a new post.
https://community.sisense.com/t5/build-analytics/how-to-create-a-table-with-a-range-of-dates/m-p/1856#M227
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)
