Count a field based on time stamp and two conditions

[#1]

Hi together,

I'm currently working on a call center dashboard and can't get my head arround some information i'd like to have. I can't even come up with some key words to search for a sulution .

I have a table showing me if an operator has logged in or out incl. the date and time for each action. 

I now want to calculate how many operator were logged in based on the selection I have made. Lets say I have seleceted the 16.03.2015, 4pm and want to know how many operator were looged in at this time. I hope someone can give me a hint on this.

Thanks and regards! 

[#2]

Hi Nitesh,

This exactly what I was looking for. Thank you very much!

Best regards,

Andreas