CRMJettyBack to crmjetty.comContact us
Menu
Docs / Guides

CRMJetty Portal

Works with
Docs / Dynamics 365

Dynamics 365 Customer Portalv6.3.0

Docs / Salesforce

Salesforce Customer Portalv6.3.0

Docs / Business Central

Business Central Portal

Guides / Admin and dashboards

How to Build a Customer Portal Dashboard

9 min readUpdated
Short answerCreate a page in Design → Page Builder, add sections and grids, then add Counter, Chart, Data Card and Recent Activity widgets and configure each one from its Settings icon. Publish the page and set it as the landing page after login.

A portal dashboard is a page that gives portal users a summary of their data the moment they sign in: open cases, order status, recent updates and charts. In CRMJetty Portal, a dashboard is an ordinary page you build in Page Builder from dynamic widgets that read data from your CRM, so you can make one for customers, another for partners and another for vendors.

The widgets show data from your CRM; the portal fetches records through your CRM’s APIs, and timing depends on your CRM’s API limits.

Before you start

Plan the dashboard

Choose a widget for each thing you want portal users to see.

Widget Shows Example
Counter A count of records with a chosen field value. Number of open cases
Chart CRM data as a Doughnut, Vertical Bar, Horizontal Bar or Line chart. Cases by priority
Data Card Records from a list in a compact card layout. Latest orders as cards
Recent Activity The latest records or updates for an entity. Recently updated cases
Global Filter One filter bar for the page. It applies to each List and Data Card widget where you turn on Enable Global Filter (Business Central: also Chart and Recent Activity widgets). Filter the case list and cards by account at once
Power BI An embedded Power BI report or dashboard. Sales performance report

The Counter, Chart, Data Card and Recent Activity widgets are included in every plan. The Global Filter and Power BI widgets are available on selected plans; see How to Filter All Dashboard Widgets at Once and How to Embed Power BI Reports in the Portal.

Create the dashboard page

  1. Go to Design → Page Builder.
  2. Select Create.
  3. Enter a Page Title, for example Dashboard.
  4. Enter a Page URL Slug, for example portal-dashboard.
  5. Enter the Page Display Name shown in menus and breadcrumbs.
  6. Set Page Access to Authenticate so only signed-in portal users can open it.
  7. Choose a Page Layout, or pick a template in Select Template.
  8. Select Next to open the page layout editor.
New page form with Page Title "Dashboard", Page URL Slug "portal-dashboard" and Page Access set to Authenticate
New page form with Page Title "Dashboard", Page URL Slug "portal-dashboard" and Page Access set to Authenticate
New page form with Page Title "Dashboard", Page URL Slug "portal-dashboard" and Page Access set to Authenticate

For every page setting, see How to Create Pages in CRMJetty Portal.

Lay out sections and grids

  1. Select the + icon on the left to add a section.
  2. In the section, select Add Grid and choose a grid layout. For a row of counters, choose a grid with three or four columns.
  3. Add more sections for charts and lists, for example a two-column grid for two charts side by side.
Page layout editor with a four-column grid for counters and a two-column grid below it for charts
Page layout editor with a four-column grid for counters and a two-column grid below it for charts
Page layout editor with a four-column grid for counters and a two-column grid below it for charts
Page layout editor with a four-column grid for counters and a two-column grid below it for charts

Add counters

  1. Select the Counter widget. It is added to the grid.
  2. Select the widget’s Settings icon to open its configuration panel.
  3. Fill in the settings below.
  4. Select Save.
Setting What to enter
Title What the counter represents, for example Open Cases.
Select Entity The CRM entity the counter counts, for example cases.
Select Field The field used to generate the count.
Select Field Value The value or values to count, for example Active.
Select Option Color The color of the counter.
Pick an Icon The icon shown on the counter.
Redirection Setting Turn on to make the counter link to a page. Choose Clickable Icon to make the whole counter clickable, or Hyperlink to show a link beneath it, then pick the page in Select Page.
Data Loading Workflow Optional. The workflow that decides which records are counted.
Counter widget configuration panel with Title, Select Entity, Select Field, Select Field Value, Pick an Icon and Redirection Setting filled in
Counter widget configuration panel with Title, Select Entity, Select Field, Select Field Value, Pick an Icon and Redirection Setting filled in
Counter widget configuration panel with Title, Select Entity, Select Field, Select Field Value, Pick an Icon and Redirection Setting filled in
Counter widget configuration panel with Title, Select Entity, Select Field, Select Field Value, Pick an Icon and Redirection Setting filled in

Tip: Point each counter at the list page for the same records, so portal users can select a counter to see the records behind the number.

Add charts

  1. Select the Chart widget, then its Settings icon.
  2. Enter a Title.
  3. Select a Chart Type: Doughnut, Vertical Bar, Horizontal Bar or Line.
  4. Select the entity in Select Entity and the field in Select Field.
  5. Choose the values to show in Select Field Value.
  6. Select Save.

For Vertical Bar, Horizontal Bar and Line charts, also fill in:

Setting What to enter
Dataset Label What the data represents, shown on the chart.
X–Axis Label The label for the horizontal axis, such as categories or dates.
Y–Axis Label The label for the vertical axis, such as counts or amounts.
Calculation Field The field the chart calculates values from.
Aggregation Types How the values are combined.
Chart widget configuration panel with Chart Type set to Vertical Bar and the Dataset Label, X–Axis Label and Y–Axis Label fields
Chart widget configuration panel with Chart Type set to Vertical Bar and the Dataset Label, X–Axis Label and Y–Axis Label fields
Chart widget configuration panel with Chart Type set to Vertical Bar and the Dataset Label, X–Axis Label and Y–Axis Label fields
Chart widget configuration panel with Chart Type set to Vertical Bar and the Dataset Label, X–Axis Label and Y–Axis Label fields

See How to Add Charts to Your Customer Portal.

Add data cards and recent activity

Data Card:

  1. Select the Data Card widget, then its Settings icon.
  2. Enter a Data Card Title.
  3. In Select Card View, select the list that supplies the data.
  4. Set the header, sub-header and other card fields you want to show.
  5. Select Save.

See How to Show CRM Records as Cards in the Portal.

Recent Activity:

  1. Select the Recent Activity widget, then its Settings icon.
  2. Enter a Title, for example Recent Activity.
  3. In Select Entity, choose the entity to show.
  4. In Select Redirection Page and Select Detail Page, choose the pages portal users open from an item.
  5. Select Save.
Recent Activity widget configuration panel with Title, Select Entity, Select Redirection Page and Select Detail Page
Recent Activity widget configuration panel with Title, Select Entity, Select Redirection Page and Select Detail Page
Recent Activity widget configuration panel with Title, Select Entity, Select Redirection Page and Select Detail Page
Recent Activity widget configuration panel with Title, Select Entity, Select Redirection Page and Select Detail Page

The Counter, Chart, Data Card and Recent Activity widgets also have HTML Class, HTML ID and Card View settings. Turn on Card View to show the widget as a card; use the class and ID to style it with CSS. See How to Add Custom HTML IDs and CSS Classes to Widgets.

Show only each portal user’s data

To limit a counter, chart, data card or recent activity widget to records related to the portal user, select a workflow in its Data Loading Workflow setting. See How to Apply Workflows to Portal Widgets.

Publish the dashboard

  1. Select Publish. The page goes live in the portal.
  2. Add the page to your navigation menu. See How to Create Portal Navigation Menus.
  3. Optionally, send portal users to the dashboard when they sign in, with a different dashboard for each role. See How to Redirect Users After Login by Role.

Tip: Once the layout works, select Save as Template to reuse it for other dashboards, such as a partner or vendor dashboard. See How to Create and Reuse Portal Page Templates.

Troubleshooting

A widget shows no data or a count of 0: Check that the entity is enabled in the portal, that the portal user’s role can view it, and that the Data Loading Workflow isn’t filtering out every record.

The dashboard doesn’t appear in page selection or menus: The page is still a draft. Publish it. See Why a Portal Page Is Missing from Page Selection.

Did this solve it?No, contact support