Hi @jiwnaiakbar
Isn’t this almost the same as https://github.com/metabase/metabase/issues/14523, but just with a slight difference instead of Sum(Distinct([column])), then you want CumulativeSum(Distinct([column]))
Or am I misunderstanding this?
Hi @flamber it is same base date but I want to show a trend on cumulative basis. so this would be something like cumulative count (distinct attended_id) / cumulative count (distinct total ID) GROUP BY DATE.
Yes. But I am struggling with SQL issue is if I do cumulative sum and group by date, it wont handle one participant attending multiple events on different days as unique.
@jiwnaiakbar Okay, couldn’t you do a count(distinct concat(attended_id, event_id)) ?
Again I don’t know your data or which database you’re using, but it sounds like stackoverflow.com or similar forums would be much better at helping you with the SQL. I’m sure that someone has asked something similar before.