My team is wanting to build a dashboard that tracks how long the issues under a specific Epic have been in progress. In progress is defined as the total number of days it takes to move an issue from "In-progress" to "Awaiting Acceptance". The idea is that for each release we could see how much of our time we are spending on each of the epics that we are trying to progress. We would calculate our time by summing the number of days it takes to move each issue in the epic from "in-progress" to "Awaiting Acceptance".
For example....if we are working on four epics, all of which are at different points in their maturity we should see different amounts of time being spent on each epic. Epics where we are performing early exploration/spikes should have a smaller number of tickets and therefore less person-days while those that are in full blown development should be occupying the majority of our time with many tickets being completed each release. If we have a dashboard for each release we should be able to see the number of person days being invested in each epic.
I played around with some of the dashboard gadgets but I did not see anything that allowed you to select the specific transitions that you want to track.