Hi @Suchithra,
Calculating the time spent in status during working hours (not only during working days) would definitely be a helpful measure. Unfortunately, for now, there is no good solution we can offer for this. However, there is an idea in our backlog to allow adding working hours as a parameter to the account, and then possibly we could pre-calculate this during import. We will update this post when anything new regarding this appears.
Meanwhile, you may try to pre-calculate this with a JavaScript calculated custom field.
- Please see this community post for a similar use case: Assignment hrs work days eazybi.
- Here is an example also in the documentation: Data adjustments using JavaScript - eazyBI.
Lauma / support@eazybi.com