I want to make EazyBI report style by referring to the Summary in Jira work management project

[xiaofeng]

Specific problems:

1. How to express the number of transactions resolved in the last 7 days

2. How to express the number of transactions updated in the last 7 days

3. EazyBI report style can be presented like Summary, for example, add custom icon to decorate.
   

   

[ilze.mezite]

Hi @xiaofeng ,

When you have created reports and charts, you can create dashboards that show several reports on one page. We offer a lot of reports and dashboards. You can see them in our DEMO account.

If you want to create something like in the picture you added, you need to create a new report, that will use pre-defined measures (1.) and one new calculated measure (2.) with the Gauge option:

1. For Done, Updated & Created in last 7 days

• choose Time in Pages & project in rows
• choose measures: Issues resolved, Issues last updated, and Issues created in columns.

To select the last seven days, in the Time dimension, define a new calculated member"last 7 days" using this formula:

Aggregate( [Time].[Day].DateMembersBetween('7 days ago', 'today') )

2. For Due in the next seven days.

• In the Time dimension, define a new calculated member “next 7 days” using this formula:

Aggregate( [Time].[Day].DateMembersBetween('today', '6 days from now') )

• In the Columns under “Measures” → “User defined” define a new calculated measure, “Issues due in next 7 days,” using this formula

( [Measures].[Issues due], [Time].[next 7 days] )

• Select just created calculated measure, go to Gauge, and choose values only. Save the report. Your report should look like this:

For the “Status overview,” create a report with Status in rows and measure Issues created in columns. Choose Pie Chart (and then Donut, to have a hole in the middle). Add data labels (percentage or value).

Also, we can’t give you a report that shows who last commented on the issue, but we can list issues that have changed in the last seven days. To do that, choose measure Issue history in columns and Issues in rows. Add Time dimension to pages and select “last 7 days”.

Now it’s time to create a dashboard to show all the reports we just created.
Add Title to the dashboard (using add Comment, format it using Markdown formatting, and add emojis.
Add reports, and you will get something like this:

We have a lot of predefined reports (and dashboards) in our DEMO account to get inspiration. If you found something you liked, export from DEMO and import them into your account.

Kind regards,
Ilze Mezite support@eazybi.com

[xiaofeng]

Thank you for your reply.
In addition to that, I have a question about how to calculate the ratio of resolved to total for a certain transaction type.
As shown in the attached figure.

[ilze.mezite]

Hi, @xiaofeng

I’m so sorry for not answering sooner! I didn’t notice your reply. I’m sorry.

We have a similar report in our DEMO account: Issues created vs resolved by priority - Issues - Jira Demo - eazyBI

For example, to create the “Type of work,” please consider using the “Open issues” measure with the “Issue Type” in the rows, and then both two columns, “Distribution” and “Percentage,” add by “Add Calculated”, see the picture for the reference:
For Bars:

And for “Percentage”, please choose “Add calculated” → % of the total.

The result should look something like this:

I hope this is what you were looking for.

Kindly,
Ilze support@eazybi.com