How to get "Number of projects created by category"

[Cedric]

Hello,
I would like to use eazyBi to report our Jira data. Except that I don’t understand the MDX language.
please help me implement the following flags:

• Number of projects created by category over the last 12 months

-Number of users created per project over the last 12 months

Thanks.

[zane.baranovska]

Hi, @Cedric,

Currently, in the Jira Issues cube, data are built around issues, and you might get data on issues selected for data import, issue projects, and users who worked on those issues. It means you can count only those projects to which you have access in Jira and are imported into your eazyBI account. Please see this community post for the expression how to count projects:

Count number of Projects an Assignee have

You can count Projects where an assignee have assigned issues. NonZero(Count( Filter( [Project].[Project].Members, [Measures].[Issues created] > 0 ) )) However, the calculation does not take into account user role in a project. eazyBI does not import project roles and related users by default. Daina / support@eazybi.com

We at eazyBI have thought of Jira Administration data (not Issue data) analysis and we have such improvement on our backlog, but I can not give you any estimates for it.

Meanwhile, you may try to create a separate account and data cube for Jira administrative reporting. You might use SQL select to Jira database or REST API as a data source for the reports.
Here are more details on how to import data from a database using SQL select or REST API and map those data to dimensions and Measures: External data sources.

Here are a few similar use cases in the Community:

How to count last login in Jira based on lisenstype (Jira-software & Jira-servicedesk)

Hi @Pederba79! I’m happy to see you have moved forward! Still, I would like to leave my feedback here. I suggest you map the LICENSE_ROLE_NAME column as a separate dimension, e.g., License role, instead of a User property. In this way, no calculated members would be necessary - you could put the time on rows and Last login count on columns and then split it by License role. Lauma / support@eazybi.com

Administrative Jira analyses

Hi @Zecchino I agree such analytics would be very interesting. However, eazyBI creates the data cube based on Jira issues selected for import and some user dimensions (like “Reporter”, “Assignee” etc) are created automatically in that cube, but users in those dimensions come from issues. And members in these dimensions have groups (jira groups) as properties that you could display in your reports. But if user is not tied to selected issues, it won’t be created in the cube user dimension autom…

Query if Jira field has value

Hi @pacerwow! In Jira issues cube eazyBI analyses only the custom fields that are selected for import as well as if they are used in the projects that are imported. Importing all projects and all custom fields for the described purpose would not be efficient. I would suggest creating a separate account and cube for analyzing custom field usage. See more details about SQL source import here https://docs.eazybi.com/display/EAZYBI/Import+from+SQL. For example, you can add an SQL source from Jira…

Best,
Zane / support@eazyBI.com