Forum Discussion
Exclude records where date is null when filtering by date range
I have a date range like this
I want to see the list of all courses (in a matrix table with information like Course, Email, Assigned at, Started at etc ) that were started within that specific time frame but the issue is when I apply the dates the table and the matrix also display the rows where the started at is null, how can I make sure that the filtering is being done right? I have multiple date columns in my table (Around 3) that I am using as a filter
PS: I want the rows with the null dates (started at and other dates) in the table, just not when a filter is applied
For the selected date range as shown above
the result should be
but the result I am getting is
and the course count is 4 as well, where as it should be 2.
4 Replies
Uzi2019Community Champion
Hi Anonymous
can you give proper input and output screnshot?
what exacty do you want?
how many tables and filter are there? how they are related. Give proper example.It would be easier for us to understand you requirements.Hi Uzi2019 I have updated the post, it's just one table with all the information in it
- Uzi2019
Hi Anonymous
You can simply select all then uncheck the blank box like below under filter on visual.
" In your case please select the date in visual filter"
I hope I answered your question Please give Kudos and accept it as a solution.
Thanks!You missed this point
"PS: I want the rows with the null dates (started at and other dates) in the table, just not when a filter is applied"
I want those rows in the table just not when a date filter is applied like in this case 'Started at'. So when no date range is selected the table SHOULD have the rows where any date is null as well.