Hello,
I have certain KANBAN and Scrum Projects.
I need a dashboard to have a bird eye view for all projects, all engineers, status of all tasks, bugs, etc.
This is what exactly i needs:
1. Filter to choose 1 or more projects out of my set of projects( Currently it is 15)
2. Filter to select 1 or more engineers
3. Filter to select time period, days, months, weeks etc
4. On Y axis I need number of tasks
5. On X axis I need Name of engineers
6. Status tab with color coding.
7 In short, If I select a project name and select time period of last 2 weeks, so this chart should show me how many engineers were assigned tasks in last 2 weeks and the break up of the tasks as per their status. Similar to the graph shown below.
what I did: I created filter in JIRA and extracted data in Excel and made a pivot chart
What I want : A live dashboard where once I create a filter this graph is visible to me on the dashboard and I can refresh it on run time.
Let me know if any plugin is available for the same and how much it costs or any other way to solve this problem.