Once the Reporting Dashboard is configured, it is time to populate the Dashboard with visual Widgets. We will continue with our configuration example from ???.
Note
I will walk through the process of adding each category of Widget - Card, Chart, and Table. However, I will not walk though configuring each individual Widget style in this example, as configuration for the various Widget styles is very similar. See OnePlan Reporting Widgets for more information on all of the Widgets available.
A Card Widget is a visual element used to display a single value, like a KPI (Key Performance Indicator) or a summary metric. It’s perfect for showcasing specific data points such as sales totals, profit margins, or customer counts in a clear and concise manner, helping users focus on the most critical information at a glance.
For this example, I will create a Card Widget that displays the total Budget for all of the Plans with data available in this Dashboard. Recall, we added a filter to the Dashboard to pull in data from Projects, Epics, and Engagements.
-
In the desired Dashboard tab, click New > Widget. This will open the Add Widget form.
-
Click Card. This will open the Add Card Widget form.
-
Complete the Add Card Widget form.
-
Title Check Box: Check the check box to display the Widget title in the Dashboard. For this example I will check the check box.
-
Title: Enter a title for the Widget. For this example I will enter "Total Budget".
-
Value: Choose a field you'd like to see summarized in the Widget. For example, I'll select Budget. This means the Card will show the total Budget for all Projects, Epics, and Engagements in OnePlan.
-
Aggregate: Select how you want OnePlan to aggregate the data for the Card. Options include: Sum, Average, Minimum, Maximum. For this example, I will select Sum, meaning I want the Card to display the sum of the Budgets of all Projects, Epics, and Engagements.
-
Display Unit: Choose the numerical format you want the Widget to use for presenting data Options inlcude None, Thousands, Millions, and Billions. For this example I will select Millions.
-
Add a Plan Filter: You can further refine the data displayed in the Widget by creating another filter. For example, you may wish to create a Widget that focuses only on Project data, and excludes Epics and Engagements. For this example, I will not create a filter for this Widget.
Warning
Filters layer on top of each other. There are filters that apply to the entire Dashboard, and you can set filters for individual Widgets. Be careful when adding Widget-specific filters because they might conflict with the Dashboard filter. If that happens, the Widget might not show any data.
-
-
Click Add. The new Card Widget will be added to the Dashboard.
-
Click Save to save the changes to your Dashboard.
A Chart Widget is a visual component that displays data graphically to help users analyze and interpret insights effectively. These Widgets can represent data in various formats, such as bar charts, line graphs, pie charts, and more, providing an interactive and customizable way to explore data trends and relationships.
For this example, I will add a Pie Chart Widget showing Budget by Business Unit for the Plans in the My Portfolio Area.
-
In the desired Dashboard tab, click New > Widget. This will open the Add Widget form.
-
Select Chart.
-
Select the type of chart you would like to create. In this example, I will select Pie. The Add Pie Widget form will open.
-
Complete the Add Pie Widget form.
Note
When setting up your chart, you will see a live preview that updates as you make your choices. This helps you confirm that your chart looks and displays the data exactly as you want.
-
Title Check Box: Check the check box to display the Widget title in the Dashboard. For this example I will check the check box.
-
Legend Check Box: Check the check box to display the Widget legend in the Dashboard. For this example I will check the check box.
-
Title: Enter a title for the Widget. For this example I will enter "Budget by Business Unit".
-
Value: Choose a field you'd like to see summarized in the Widget. For example, I'll select Budget, as I want to look at the total Budget broken down by Business Unit.
-
Aggregate: Select how you want OnePlan to aggregate the data for the Card. Options include: Sum, Average, Minimum, Maximum. For this example, I will select Sum because I want to look at the total Budget broken down by Business Unit.
-
Group By: Select how you would like the data in the Widget to be organized. For this example, In this example, I will choose Business Unit to see the total Budget divided by each Business Unit.
-
Lables: Select how you want the different components of your chart labled. Options include: No Value (no lable), Show Values (showing the raw values), and Show Percent of Values (showing the values as a percent out of 100). For this example, I will select Show Percent of Values.
-
Display Unit: Choose the numerical format you want the Widget to use for presenting data Options inlcude None, Thousands, Millions, and Billions. For this example I will select None, since I choose to display the lables as percents.
-
Add a Plan Filter: You can further refine the data displayed in the Widget by creating another filter. For example, you may wish to create a Widget that focuses only on Project data, and excludes Epics and Engagements. For this example, I will not create a filter for this Widget.
Warning
Filters layer on top of each other. There are filters that apply to the entire Dashboard, and you can set filters for individual Widgets. Be careful when adding Widget-specific filters because they might conflict with the Dashboard filter. If that happens, the Widget might not show any data.
-
-
Click Add. The new Pie Chart Widget will be added to the Dashboard.
-
Click Save to save the changes to your Dashboard.
A Table Widget is a visual element used to present data in a tabular format, similar to a spreadsheet. It organizes data into rows and columns, making it easy to display detailed information, compare values, and perform data analysis at a granular level. Users can customize and interact with tables to gain deeper insights.
For this example, I will create a Table Widget that displays a summary of Projects, Epics, and Engagements.
-
In the desired Dashboard tab, click New > Widget. This will open the Add Widget form.
-
Select Table. The Add Table Widget form will open.
-
Complete the Add Table Widget form.
-
Title Check Box: Check the check box to display the Widget title in the Dashboard. For this example I will check the check box
-
Display Totals: Checik the check box to display the table totals in the Dashboard. For this example I will check the check box.
-
Title: Enter a title for the Widget. For this example I will enter "Portfolio Summary".
-
Columns: Select the plan fields you would like to display as columns in the table. For this example, I will select Plan Type, Name, Estimated Start, Estimated End, Business Unit, Category, State, Status, Budget, Benefits, ROI, Associated Key Results, and Prioritization Score.
-
Group By: Select how you would like the data in the Widget to be grouped. For this example, I will leave this blank.
-
Sort By: Select how you would like the data in the Widget to be sorted. For this example, I will select Estimated Start.
-
Sort Direction: Select the direction you would like the sort to go. Options include Ascending or Decending. For this example, I will select Ascending.
-
Add a Plan Filter: You can further refine the data displayed in the Widget by creating another filter. For example, you may wish to create a Widget that focuses only on Project data, and excludes Epics and Engagements. For this example, I will not create a filter for this Widget.
Warning
Filters layer on top of each other. There are filters that apply to the entire Dashboard, and you can set filters for individual Widgets. Be careful when adding Widget-specific filters because they might conflict with the Dashboard filter. If that happens, the Widget might not show any data.
-
-
Click Add. The new Table Widget will be added to the Dashboard.
-
Click Save to save the changes to your Dashboard.