Use of Rovo in generating utilisation reports

[Febin Philipose]

Hi, 

I love using ROVO, and as a delivery manager, one of my key responsibilities is to find out if the resources in my team are under- or over-utilised against their planned capacity.

I have been prompting Rovo with the logic and calculation to compare the capacity (including deduction of planned leaves) in a three-week sprint in hours against the time spent or logged in a Jira ticket, with an expectation from the team to ensure they have atleast 80% time logged in their assigned tickets within a sprint.

I was able to extract the report in confluence but the biggest challenge is:

• Rovo takes a lot of time to identify and compare the capacity v/s time spent, and at times pauses, and if you prompt it again, re-validates the calculation again, taking almost 15-30 minutes again to re-process again. So I need to be on the Confluence page till this is analysed.

Do you think having an agent to do this would be helpful? The challenge here is, every time I need to extract the time spent in csv and attached it to Rovo. I wish I could create a ROVO custom agent with the time-track gadget in-built to avoid this manual csv upload process and ensuring utilisation report updates automatically weekly, monthly etc. That could be really helpful.

Reaching out to the community here to help if is there is a solution.

Kind regards,

Febin