Slicer widgets

A slicer widget is a single-column table which is used to filter other widgets on the dashboard. It automatically broadcasts a filter event for the selected row to any widgets such as bar and pie charts which have been configured to receive filter events (see Configure widgets to broadcast and receive filters).

Note Only one broadcasting slicer or table widget is active at a time on a dashboard.

Note The data models which provide current data should be used for this widget; for example, Contracts or Communications. The History data models should only be used if the data request is restricted to current data by applying a filter: include $filter=RowIsCurrent eq 'Yes' in your URL.

Add a slicer widget

To add a slicer widget to a dashboard:

1. Click the drop-down arrow on the dashboard tab and select Add Widget.

   The Add Widget window is displayed.

2. Click the name of the widget you want to add to the dashboard.

   The dashboard is refreshed to show the new widget ready for configuration.

   Tip You can drag the widget to a different location on the page, e.g. to a different column, and to above or below existing widgets. You can also resize the widget by dragging the edges to change the height or width.

Configuration field descriptions

Note Fields marked with an asterisk are required.

Widget configuration

To configure the slicer widget:

3. If necessary, click Edit on the title bar of the widget to open its properties.

   Note Fields marked with an asterisk are required.

4. Enter the Title of the widget.

5. Enter the Rest URL of the data model which will be used in the widget, typically https://YourServer/ProConAnalyticsAPI/datamodel where datamodel is:

   • Contracts

   • BreakdownItems

   • LineItems

   • Communications

   • CommunicationReviews

   • CommunicationLineItems

   • Obligations

   • Tenders

   • ScheduleItems

   • TenderReviews

   • StageGates

   If necessary, customize the URL to select, filter, sort and limit the data - see Specifying URLs for more information.

   Tip By default, data is returned from deleted contracts/tenders which are in the recycle bin.

   Include $filter=IsDeleted eq 'No' in your URL to exclude this data.

Broadcast filter events

The slicer widget automatically broadcasts filter events when any of the rows in the table are clicked.

See Configure widgets to broadcast and receive filters.

Example

Business unit dashboard.

Lists the categories of the tenders in the business unit. If a category is selected (displayed in bold), widgets which are set to receive filter events will show only the data for tenders in that category.