Hello All,
I would need someones help with frequency formula. never used it and now i need it for some of my work, i can come up with basic one but not with one with multiple criteria.
So here is what i need help on, i have a document with persons working times. Based on that i need to be able to calculate how many days they have worked by counting status "Connected" only once per day. I have below recreated the layout of the data. Criteria is based on country, weeks, persons ID, status what should be considered is "Connected". (please note that there will be drop downs and based on selected week and ID i need to be able to see their working days).
Hope the table makes sense
And thank you in advance!
<tbody>
</tbody>
I would need someones help with frequency formula. never used it and now i need it for some of my work, i can come up with basic one but not with one with multiple criteria.
So here is what i need help on, i have a document with persons working times. Based on that i need to be able to calculate how many days they have worked by counting status "Connected" only once per day. I have below recreated the layout of the data. Criteria is based on country, weeks, persons ID, status what should be considered is "Connected". (please note that there will be drop downs and based on selected week and ID i need to be able to see their working days).
Hope the table makes sense
And thank you in advance!
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | UK | <- This is dropdown | |||||||||||||||||||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | UK | 25 | 6 | 2018 | Monday | Week | 25 | <- This is dropdown | |||||||||||||||||||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | UK | 25 | 6 | 2018 | Monday | ID | 1234 | <- This is dropdown | |||||||||||||||||||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | UK | 25 | 6 | 2018 | Monday | Days worked? | ? | Based on statuses "Connected". | |||||||||||||||||||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | UK | 25 | 6 | 2018 | Monday | Result should be | 4 | ||||||||||||||||||||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | UK | 25 | 6 | 2018 | Monday | ||||||||||||||||||||||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | UK | 25 | 6 | 2018 | Monday | ||||||||||||||||||||||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | UK | 25 | 6 | 2018 | Tuesday | ||||||||||||||||||||||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | UK | 25 | 6 | 2018 | Tuesday | ||||||||||||||||||||||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | UK | 25 | 6 | 2018 | Tuesday | ||||||||||||||||||||||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | UK | 25 | 6 | 2018 | Tuesday | ||||||||||||||||||||||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | UK | 25 | 6 | 2018 | Tuesday | ||||||||||||||||||||||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | UK | 25 | 6 | 2018 | Wednesday | ||||||||||||||||||||||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | UK | 25 | 6 | 2018 | Wednesday | ||||||||||||||||||||||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | UK | 25 | 6 | 2018 | Wednesday | ||||||||||||||||||||||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | UK | 25 | 6 | 2018 | Wednesday | ||||||||||||||||||||||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | UK | 25 | 6 | 2018 | Thursday | ||||||||||||||||||||||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | UK | 25 | 6 | 2018 | Thursday | ||||||||||||||||||||||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | UK | 25 | 6 | 2018 | Thursday | ||||||||||||||||||||||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | UK | 25 | 6 | 2018 | Thursday | ||||||||||||||||||||||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | UK | 25 | 6 | 2018 | Thursday | ||||||||||||||||||||||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | UK | 25 | 6 | 2018 | Thursday | ||||||||||||||||||||||||
<tbody>
</tbody>