Newbie for Atlassian Analytics. Need learning material and learning path for building dashboard

[Venkatesh Parthiban_G]

Am trying to create a dashboard in Atlassian analytics. For which one of the chart below is the logic 

I want to build a report like this which need to show total Feature Percentage based on below logic It should count the sum of original estimates of story, task and bug with labels FEATURE, TECH_DEBT & INNOVATION. No other tickets Lets assume if the Total estimate is 1000 hours (only the ticket that has any of the above mentioned labels) Tickets with Label "FEATURE" is 500 hours Ticket with Label "TECH_DEBT" is 300 hours Ticket with Label "INNOVATION" is 200 hours It should show FEATURE - 50 %

I can either show Feature , Tech Debt and innovation percentage in pie chart or separate Single Chart Indicator for each different labels. 

Also it wil be fine if learning path or dashboard is provided for the same ?

[Samuel Ng]

Hi Venkatesh, 

Are the labels mutually exclusive? For example, if a work item has the "FEATURE" label, it can't have the "TECH_DEBT" or "INNOVATION" labels tagged to it, and vice versa. If the labels are not mutually exclusive, I'm afraid there's no straightforward way to group them by their original time estimate, at least not one that comes to mind at the moment.

You'll need two columns to create a pie chart. You can use the total sum of the "Original time estimate" field and potentially the "Labels" field, if they're mutually exclusive, so that you can group by their values or a different field, such as the "Work type". Both fields can be found in the same "Work item" table (or the jira_issue table in SQL mode). Please refer to the Schema for Jira family of apps for more details.

A sample screenshot of the pie chart I created on my test instance, based on the work type and original time estimate, is as follows:

If you need more help, please feel free to raise a support ticket with Atlassian Support.