Specific problems:
How to express the number of transactions resolved in the last 7 days
How to express the number of transactions updated in the last 7 days
EazyBI report style can be presented like Summary, for example, add custom icon to decorate.
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:
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') )
Aggregate( [Time].[Day].DateMembersBetween('today', '6 days from now') )
( [Measures].[Issues due], [Time].[next 7 days] )
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
