eazyBI: Generating team performance reports in eazyBI from JSM form data
Alright, here’s a tough one—I hope someone can help me out.
A civil engineering company wants their site managers to log each team's work at the end of the day. They can do this using a form in the JSM Customer Service Portal. Every field in the form directly maps to a Jira custom field. To make things clearer, I’ve attached an overview of the fields.
Each site manager can report up to 5 teams per ticket, and for each team, they can log up to 5 work items, including quantity. The dropdown options are the same across all 5 team fields and the 25 work item fields. Each work item field has an additional number field for the quantity.
The goal is to generate either one big report or, if that’s not possible, multiple smaller reports (e.g., per team). These reports should show, for example, how many square meters of asphalt a team has logged over a certain period (e.g., calendar week, last 30 days, etc.).
Is there any way to do this with eazyBI?
Big thanks to anyone who’s made it this far and understands what I’m getting at. The AI in the eazyBI app seems to struggle with this—it’s not giving me useful solutions.
