Need to report number of people in a specific user role in jira projects

Questions & Answers
,
1

Hi All
Need a specific report that shows number of people in a specific role in a list of jira projects. For eg: lets say we have 3 Jira projects, Project A,B and C. and we have 2 developers in each of the project. need a report that tracks this. So report need to show 6 developers in total.

I see eazybi does not get user roles from projects so this is a bit difficult to get from native import.
However Jira has a rest api that gets these information. Is it possible to use rest api to build such a report?
Need some help over here.

2

Hi @Vinu,

The eazyBI data model is built around issues when importing data from Jira.

However, you may enrich the data with additional data import from other data sources using REST API, SQL select, Google Sheets, or files. This way, you may create new Measures and properties, but a creation of new dimensions is not supported.

In your case, you might want to retrieve the project key and count of users for each project role, developer, customer representatives, manager, etc. The additional data might contain one row for each project and the following information:

  • project key or name to look up for a project and import additional data. Make sure to mark advanced option Skip missing.
  • count of developers, import it as a new measure representing a count of developers for each project
  • count of customer representatives, import it as a new ** measure** representing a count of customer representatives for each project
  • count of managers, import it as a new ** measure** representing a count of QA users for each project

The data mapping screen might look like in the picture below:

Data-mapping for user roles
Data-mapping for user roles2466×1042 359 KB

More details on the additional data import and how to map the data are here:
https://docs.eazybi.com/eazybijira/data-import/jira-issues-import/additional-data-import-into-jira-issues-cube.

Measures imported this way works well together with dimensions that are mention in the data mapping screen (in your case, Project dimension). If you would like to use other dimensions in the report, then you might want to define a new calculated measure to incorporate measures that are imported from other data sources. For the calculation use function DefaultContext() and a tuple of a measure and dimensions it was mapped to:

DefaultContext(( 
  [Measures].[Developers],
  [Project].CurrentHierarchyMember
))

More details on calculated measures, tuples, and function DefaultContext() are here:
https://docs.eazybi.com/eazybijira/analyze-and-visualize/calculated-measures-and-members
https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/mdx-function-reference/defaultcontext

I would recommend watching a training video on additional data import to get a better understanding of how this works and how imported measures could be used in the reports:
https://docs.eazybi.com/eazybijira/learn-more/training-videos/training-videos-on-specific-topics#Trainingvideosonspecifictopics-BuildingReportsonDifferentDataSources(20min)

Best,
Zane / support@eazyBI.com