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 report, adding status indicators to your Jaspersoft report, creating 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 Webinar series.
To get in depth training, join Rego at regoUniversity in Tempe, April 25-27.
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.
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.
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 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!
*This post was first published on Rego Consulting's Blog. Subscribe there for free training.
Thanks for sharing this, Camille
Does this work with calculated fields? I have a spider diagram with "Region" as a calculated field. I also have a table (list of issues) with same "Region" calculation. Have setup Hyperlink in Dashboard so that "Region" on spider dashlet affects "Region" on table dashlet.
When in display/view mode, I can deselect Regions from the spider diagram, clicking on them in the Legend. However, the table content remains unchanged - all regions continue to show in list.
On 15.2 with JS 6.2.1.