Ranking component

Use the Ranking chart component to show minimum or maximum values within Data Sets, displayed as a chart or table. With the Ranking component, you can easily visualize extremes within your data, such as the top ten rooms with the greatest demand for electricity.

The Ranking component will show the highest or lowest values, in ascending or descending order. You can choose the number of results to show.

Use the following steps to create a Ranking Component chart:

1. Add a Ranking component to a report and click the component's Edit icon in the component's banner.
2. Click Edit in the menu.
3. Click Add Report Data and click a Data Set to include in the component.
4. On the Edit tab of the Edit Ranking Component page, select Chart.
5. In the Show box:
• Select Highest or Lowest for the sorting direction.
• Select the number of results you want to include in the report.
• Select Descending or Ascending for the display order of the columns.

These options are used in conjunction with the KPI selector (see below).

6. Click Add Report Data and add one or more Data Sets to the component data grid.
7. Click the KPI (Key Performance Indicator) selector to specify that the data series in the selected Data Set is your prime area of interest.

During the comparison of the data series included in the Data Sets, your KPI selection determines the data series that will be ranked. In some cases, that data series uses more than one Data Set, as shown in the Query column in the following image. The ranking is displayed according to the Show options.



8. Click Display chart legend to display a legend for the generated chart.
9. Click OK.

© 2019 Reliable Controls Corporation. All rights reserved. Published October 29, 2019