In the latest free Jaspersoft training from Rego, we’ll show you how to make a Masterful Jaspersoft Dashboard in just five minutes. Rather than moving from report to report to report, the dashboard below gives you one view for drilling into Projects by Stage.

In recent Jaspersoft posts, we’ve shown you how to create the foundation for this speedy dashboard by starting your ad hoc report from scratch, creating a table for an active project reportadding status indicators to your Jaspersoft reportcreating a crosstab report for allocations and assignments by project, and making a Jaspersoft chart with project count, stage, and status. And we did it all in CA PPM, where you can now email Jaspersoft reports to anyone.

Today we pull those reports together in one magnificent dashboard with guidance from Atul Kunkulol, who shared this trick in Part 1 of our Free Jaspersoft 6.1 Webinar series.

To get in depth training, join Rego at regoUniversity in Tempe, April 25-27. 

Jaspersoft Dashboard | Shortcut

From CA PPM Advanced Reporting Home, beneath Dashboards, select Create.

Dashboards bring all of your content together in one place. On the left of your screen, beneath Existing Content, you can see all the content available to create your dashboard. This includes stock reports and ad hoc views.

When we search for the recently created content, mentioned above, the list looks like this.

Drag and drop the relevant reports over to the center staging area, and start sizing the boxes by dragging their sides while they load.

Hyperlink Jaspersoft Dashboard Reports

Now you have a dashboard showing the number of projects by stage.

To take your dashboard to the next level, you can hyperlink the reports, or dashlets, so that selecting a section of one report makes the others drill into related data. Right-click on the desired report and choose Properties.

From the Hyperlinks tab, we can enable chart hyperlinks, and update the dashboard here or within a new page.

We’ll select “Create Links in Filter Manager,” confirm yes to save dashlet properties and close the window. Now the Filter Manager will bring up the Count by Stage.

Select the Stage plus icon, add the report to Select Dashlet, and Select Parameter.

Assign the stage as a parameter by pressing the plus icon again. The same stage will now go to project allocations.

Take Note: If we had added stage to our Project Stage Count report, we could have added it here, as well. Because we didn’t, as you see below, the stage parameter is unavailable. Press OK.

Preview the Jaspersoft Dashboard

To preview your dashboard, click on the eye icon.

The display mode will allow us to select each report, and view our custom dashboard.

We can click on our Project Stage Count to select a business case. This action will repopulate the data in the Project Allocation and Project List to reflect that selection and show us all the allocations that are related to the case we selected, within that stage.

Wow, right? It’s so powerful.

Save the Dashboard

Save the dashboard by selecting the disc icon. We’ll put it in the Shared folder under Dashboards, so we can pull it up by phone or tablet walking into a conference room.

We just created an Ad Hoc Jaspersoft Dashboard showing Projects by Stage.

Stay tuned for instructions on how to use the JasperMobile App. And check out regoUniversity for onsite CA PPM training at a price you can afford, April 25-29. The registration deadline is approaching!

Join our mailing list below.

About the Author: Rego Consulting

As the leading Strategic Portfolio Management (SPM), Project Portfolio Management (PPM), Technology Business Management (TBM), Agile and expert services provider, Rego Consulting has helped hundreds of organizations achieve a higher return on their software investment, including 60% of Fortune 100 and 70% of Fortune 20 companies.

Share This Story, Choose Your Platform!

Stay up-to-date. Join our newsletter!