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.
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”.
BR
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.
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, Did solution from @David_Wong work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved.
Regards,
Karthik