Hello everyone,
Is there a way to create a filter in a metric or columns widgets that returns the number of active users based on the shift ? (Morning: 7 am-3 pm, Night: 3pm-11pm, overnight: 11pm-7am)
Note that it needs to be refreshed daily
does anyone has an answer to this one?
Thanks in advance.
Like
Dear Anas,
To achieve this functionality you can add a new boolean field (for example: IsActive) for users. This field will be updated by a business process that will start every hour.
The business process can set the value of the IsActive field according to the filtration or you can create an object where you will specify the shifts that users have.
I hope this helps. Have a great day!
Alina Yakovlieva,
Thank you for responding!,
could you please elaborate more about the steps that you provided?