Line chart widgets

Line chart widgets display information from a specific data model, according to the filters applied to the Rest URL for the data, as a single line graph.

You can group and aggregate the data as required, limit the number of records displayed, and receive filter events which apply to the chart.

The X axis of the chart displays the values from the specified Group By field; the Y axis displays the values from the field selected for Aggregation.

Clicking a point on the line drills through to the Detail View, which displays a table of data filtered according to the point that was clicked . For example, if a line chart is grouped by CommunicationState, clicking the point for the count of Draft communications will open the Detail View to display the data for Draft communications only.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.

Note Column names longer than 10 characters will be truncated.

Add a line chart widget

To add a line 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 line 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 Group By field, enter the name of the field by which you want to group the data.

   For example, to group communication data by the state of the communications, enter CommunicationState.

7. In the Aggregation section, select the Type (Average, Count or Sum) and enter the Column Name for the field by which you want to aggregate the data (not required for Count).

8. If desired, enter the X Axis Title and Y Axis Title. If these are not set, the field names are used.

9. You can click Save to display a line chart of all the data returned by the specified Rest URL and specified fields, or continue to refine your widget data before saving.

Limit the displayed records

You can limit the number of records displayed in the chart, based on a sort of the values of the Group By field. Limiting the records displayed also sorts the data in the chart by ascending/descending order.

To limit the number of records displayed:

10. From Limit Records, select:

    • Top to show the first X records.

    • Bottom to show the last X records.

    Tip Numeric values are sorted in ascending order (smallest first). Therefore, for fields which have numeric values, you must specify Bottom to get the records with the highest values or Top to get the records with the lowest.

11. Enter the number of records you want to display in the Record Count field.

12. Select Include Tied Results if you want to display all records which rank equally in the top or bottom X, even if this means that more than X records are displayed .

Receive filter events

See Configure widgets to broadcast and receive filters.

Example

Business unit dashboard.

Displays the total number of contracts for each project.