We use Zammad quite extensively, but we need better reporting, the main part that we need is how the ticket was resolved and that must form part of the report. We thought Power BI can help with this, but can Power BI work with Zammad or is there another way you would do this?
This may not be the solution you are working for. We use PowerBI for reporting on our tickets although we don’t integrate with Zammad. We pull from the Zammad database and feed that information into PowerBI for reporting.
Also, when tickets are closed we add a keyword to signify that that the ticket is closed and follow that keyword with an explanation of the resolution.