Stacked bar chart widgets

Stacked bar chart widgets display information for a single field from a specific data model, according to the filters applied to the Rest URL for the data, grouped in bands of values.

For example, you can display the number of communications which require response grouped by how many days until they are due, in bands of 0-1 days until due, 2-4, 5-6, 7-8 and over 9 days.

Clicking a band of the bar drills through to the Detail View, which displays a table of data filtered according to the band that was clicked. For example, if a stacked bar chart showing the days that an obligation is overdue has bands representing 10 days, clicking the band for 0-10 days will open the Details View to display the data only for obligations which have DaysOverdue values between 0 and 10. See Configure the Detail View for more information.

Note Drill-through on charts is not available to the Administrator when creating and updating standard dashboards.

You can receive filter events which apply to the chart.

Add a stacked bar chart widget

To add a stacked bar chart 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 stacked bar chart 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.

6. In the Banded Column section, enter the Column Name for the field for which you want to group values into bands. The values in the field must be numeric.

   If desired, enter a Display Name for the field (e.g. a short name or friendly name). This is used in the chart's key.

7. In the Bands section, enter the Low and High values for each band.

   Click Add to add more bands.

8. You can click Save to display a stacked bar chart of all the data returned by the specified Rest URL and field, or continue to refine your widget data before saving.

Receive filter events

See Configure widgets to broadcast and receive filters.

Example

Business unit or contract dashboard.

Displays the number of communications for each defined band of the number of days until the date that a response is due.