whenever i select a date on which i dont have any entry in my data it shows all the data from my dataset.
suppose i want to find no of employee left the organization on a particular date suppose i select 1 jan 2022 but in my data no one left on this date but when i select this date it shows count of all the records i am having in my dataset.
There is no Set analysis just use sum(sales) and when you select any two dates from that date picker it should show sales between those two dates and if there is no sales between those two dates then it should show null or zero sales.
