Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
What is your set analysis and how is your data connect to the calendar? I would expect it to return null when no values are on that date.
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.