Filtering Data using Date Filter

I would like to view all employees, even if their data row for a certain date is blank.
If I select a date from this year, I want to see all employees. I have attached a sample screenshot.

Data Set

Hi @Vaibhav.narwade
you want to see “this year” and all “blank”?
So you assume each “blank” is also this year or it doesnt matter?

You could create a date parameter and calulated field and setup a filter for the field.

ifelse({date}>${pDate} OR isNull({date}),1,0)

But not sure you can use “relative dates”.


1 Like

hello @ErikG
I have tried the calculated field you gave but it is not working at all.
if suppose i select a project then I want all employees of that project and logged hrs that time i don’t need any date.

Hi @Vaibhav.narwade
what exactly didnt work?

1 Like

calculated field that you have provided

did you adjust it to your dataset?
I assume you dont have a parameter called “pDate”

1 Like

Hi @Vaibhav.narwade,

When you create your date filter, you can select “Include nulls”.

1 Like

Hi @Vaibhav.narwade, Did solution from @David_Wong work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved.


@Karthik_Tharmarajan Yes Please