I have a visualization requirement and I know cumulative count is the answer but unable to figure out how.
There is a base table with list of registered participants. example table below:
I have event table as below:
One participant can attend multiple events. Event_Log will have who all attended the events as below:
I want to show a daily cumulative line chart report of %unique participants coverage
|Date||# Registered||# Unqiue Covered||% Covered|
|27-Jan-21||7||5(note: 1 attended twice so ignored)||71%|
I also want to City filter on the top to show the same report for selected city!
Sorry for such long description but I feel I am there and yet I am unable to get what I want.