Hi @Henk!
I would suggest you filter all issues that have transitioned to the statuses in the period of time and then add the days in status for the status group you are interested in. A similar example is here Lead + cycle time to replace JIRA Control Chart.
Let me know if that helped or if you have further questions regarding this!
Lauma / support@eazybi.com