Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Complex filter: "Hours per week"

Hi guys, I have a table where people book hours. However, some of the "entities" that book hours are not people, but teams comprising of more people. I only want to filter  out the people. A rule...
Need Help
  • Nathaniel_C's avatar
    Nathaniel_C
    7 years ago

    Hi Anonymous ,

    Then you will have to do a column where the total per week is accumulated. Probably use Calculate based on person and time frame.


    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
    Nathaniel

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Nathaniel,

 

Thanks for the quick reply! Unfortunately it does not work, everyone has been flagged as "Individual".

People book daily (6-9 hours), but I want to base the filter on the weekly average.

Nathaniel_C's avatar
Nathaniel_C
Icon for Community Champion rankCommunity Champion
7 years ago

Hi Anonymous ,

Then you will have to do a column where the total per week is accumulated. Probably use Calculate based on person and time frame.


Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel