Subscribe Join 34,000+ subscribers and receive articles from our blog about software quality, testing, QA and security. Subscribe

Metric of % automated for milestone

I want to extract a metric to see the % of automated tests assigned to the milestone.
I want to extract this metric to our corporate dashboard and to do so I need to do multiple calls to TestRail which is limited per minute (we use Cloud hosted instance).

Current workflow that I see is:
Get milestones -> Get TestPlans for each milestone -> Get Runs for each TestPlan -> Get Cases from each run and then check their custom_automation attribute equals 5, aggregate count per milestone.

Is there a more efficient way of doing that?