i need some help finding the best way to handle the below scenario:
i have a main table transactions having sales per store, day. another table in my schema is the events table with the key Store & day and event name. so from my transactions table i can see the sum(sales) per event.
now sometimes this store can be closed for renovation for example with a specific event name 'renovation', i need to add a button when clicked it will exclude from the chart the stores that have renovation to note that not all the days in my transaction table have events so the option of excluding the event renovation from the filter will not work as it will select all the events except the 'renovation' event which is not my case, also if i add it to the set analysis event-={'renovation'} it will do the same behavior.
