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
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
