Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Calculate No response

Dear all, I want to extract list of employees who dont fill out the response form. Available data: 1. I have list of total employees. 2. Response from employees who fill on daily basis. Issue: ...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hii... Thanks!! I tried this, but its showing whole people who doesnt fill.

I am looking for who didnt fill response by each day... I have time stamp in response sheet. Any solution pls?

 

TIA

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

 

Can you pls share sample data and how does your data model look like.

 

Regards,

Harsh Nathani

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Anonymous az38 amitchandak Please support

     

    Hi...

    Below are table 1 Rsponse table and table 2 is employee database. I want to pull out name of employees who didnt fill the response sheet daily.

     

    So, I need daywise employee name who filed to fill. 

    If I filter for 22nd in merged sheet, I want Name "P" in non filled and M on 21st.