How to Create a Custom Dashboard
This page explains how to create a custom dashboard that displays links, charts, and data tables in a grid layout. Dashboards are built from menu items and menu categories using the standard menu system.
Prerequisites
- You must be a Configuration User.
- You should understand how dashboards are assembled from menu categories and menu items. See Dashboards Overview and Dashboard Layout.
How Dashboards Work
A dashboard is not a single entity. It is assembled from:
- A menu item that invokes the dashboard and specifies the grid layout.
- Menu categories that populate each cell of the grid.
- Menu items within each category that appear as links, charts, or tables depending on their Display Type.
Step 1: Create Menu Categories for Each Cell
Each cell in the dashboard grid needs its own menu category.
- Navigate to Admin > Menu Categories.
- Click New to create a new menu category.
- Set the category type to Dashboard.
- Name it descriptively (e.g., "My Dashboard - Top Left", "My Dashboard - KPI Charts").
- Save. Repeat for each cell you want in your dashboard.
Step 2: Add Menu Items to Each Category
For each menu category you created, add the menu items that should appear in that cell.
- Navigate to Admin > Menus.
- Create a new menu item within the category.
- Set the Display Type to control how the item appears:
- Menu -- displays as a clickable text link.
- Query or Chart -- renders a query's results or chart directly on the dashboard.
- Query with Help Text -- same as above, but shows the tooltip text as a description above the content.
- Use the Menu Command Builder to configure what the item does (e.g., display a query, open a form).
- For chart cells, ensure the underlying query has its presentation set to a chart type (bar, pie, line, etc.) in the Query Editor.
- Save the menu item.
Step 3: Create the Dashboard Menu Item
- Navigate to Admin > Menus.
- Create a new menu item for the dashboard itself.
- Open the Menu Command Builder tab.
- Select the command type and assign your menu categories to the grid positions (rows and columns).
- Set the Menu Category of this dashboard menu item to the location where you want it to appear in the main menu (e.g., in a dropdown).
- Set the Sort Code to control where it appears relative to other items.
- Save the menu item.
Step 4: Test the Dashboard
- Refresh the browser page.
- Navigate to the menu item you created.
- Verify the dashboard grid displays correctly with your charts, links, and tables.
Creating a Tabbed Dashboard (Optional)
For dashboards with multiple tabs (sub-dashboards):
- Create a top-level menu item. In the Menu Command Builder, set the command to Display a Form, select the form "Dashboard Container", and set the Script to "Dashboard Container Script".
- Set the Menu Category of this top-level item to a category of type "Dashboard Menu Item".
- Create separate menu items within that category for each tab. Each tab is a standard dashboard with its own grid of menu categories.
- Configure each tab's grid using the Menu Command Builder.
Tips
- The fastest way to create a new dashboard is to clone an existing dashboard's menu item and modify the copy. Examine the cloned menu's command to see how the grid and categories are set up.
- If a dashboard cell appears empty, check that its menu category has menu items assigned to it.
- After creating or modifying a dashboard, refresh the browser to see changes.
Related Articles
- Dashboards Overview — how dashboards are assembled
- Creating a Dashboard — full reference with screenshots
- Dashboard Layout — understanding the grid system
- Menu Categories — creating categories for dashboard cells