In the Eagle Portal, you can create and publish dashboard parts as well as configure dashboard parts to suit the unique requirements of your business.
Configure a Chart Dashboard Part
In the Chart dashboard part, you can configure various options and define point labels by using keywords.
To configure a chart dashboard part:
- From the Eagle Portal main window, click Dashboards.
You see the Dashboards window displayed in the default view. - Click the Manage drop down menu and select Parts.
You see the Parts window with all the dashboard parts available to you. - Click New.
You see the Define window where you can select Define window options, including the part type and fields. - Enter the Part Name and select the Category.
- For Select part type, click to select the Chart or the Chart and Data option.
- Enter the appropriate information for the other Define window options and click Next.
You see the Design window where you can select Design window options, including column options and calculations. - Enter the information in the appropriate options and click Next.
You see the Display window where you can select Display window options, including the chart type and how the chart is labeled and displayed. - Under Chart Options, click to select the chart type and complete the options in the Series dialog box.
- Click to select additional chart options:
– Click the Show chart in 3D check box to display the chart in a 3D view.
– Click the Show Labels check box to display the labels for the x and y axis and enter the label values in the Axis X Title and Axis Y Title text boxes, respectively.
– Click the Enable Legend check box to show a legend with the chart.
– Click the Data Labels drop down to select the location of data labels.
– Click the Trendline drop down to display a trendline on the chart.
– Click the Color Palette drop down to select a color theme other than the default. NOTE: The Eagle Portal Administrator can change and configure the theme colors.
– Click the Show Point Labels check box to show labels on the chart and enter the point label format keywords in the Point Label Format text box. See the Point Label Keywords Used in Charts section. - Enter the appropriate information for the other Display window options and click Next.
You see the Publish window. - Enter the information in the appropriate Publish window options.
- Click Finish to save your changes to the dashboard part.
You see the updated part in the Parts window. - Click Manage Dashboard Views to return to the Views window. Or, click Return to Dashboard to return to the Dashboards window in the current view.
Point Label Keywords Used in Charts
The following table lists keywords that you can enter into the Point Label Format text box when you are creating or editing a chart dashboard part.
NOTE: All keywords must be entered in upper case.
Keyword | Description | Multiple Y Values | Formatting Allowed? |
#VALX | X value of data point. | No | Yes |
#VAL | Y values of the data point. | Yes | Yes |
#SERIESNAME | Series name. | No | No |
#LABEL | Data point label. | No | No |
#AXISLABEL | Axis data point label. | No | No |
#INDEX | Data point index. | No | Yes |
#PERCENT | Percentage of the data point Y value. | Yes | Yes |
#LEGENDTEXT | Legend text. | No | No |
#CUSTOMPROPERTY(customAttributeName) | Value of the named custom attribute. | No | No |
#TOTAL | Total of all Y values in the series. | Yes | Yes |
#AVG | Average of all Y values in the series. | Yes | Yes |
#MIN | Minimum data point of all Y values in the series. | Yes | Yes |
#MAX | Maximum data point of all Y values in the series. | Yes | Yes |
#FIRST | First data point of all Y values in the series. | Yes | Yes |
#LAST | Last data point of all Y values in the series. | Yes | Yes |
Point Label Keywords with Multiple Y Values
If a chart type contains more than one Y value, you can show Y value specific calculation in some keywords by appending the Y value position to the keyword.
For example, to show the open, close, high, and low values in a stock chart, enter the following: "#VALY, #VALY2, #VALY3, #VALY4" in the Point Label Format text box.
Point Label Keywords with Formatting
Several keywords allow formatting. To format the output of a keyword, at the end of the keyword, you can add a standard numeric format string or custom numeric format string encapsulated in curly brackets.
When you use a standard numeric format, the Eagle Portal uses your system's regional settings to display the calculated values in the local format, such as the Japanese Yen for currency. For example:
- To represent Y values as currency, enter "#VAL{C}" in the Point Label Format text box.
- To represent positive Y values as dollars with negative values shown as positive dollars encapsulated by parentheses, enter"#VAL{$#,##0.00;($#,##0.00)}" in the Point Label Format text box.
The following table lists formatting options that can be used with the point label keywords.
Format Specifier | Name | Description | Examples |
"C" or "c" | Currency | Result: A currency value. | 123.456 ("C", en-US) -> $123.46 |
"D" or "d" | Decimal | Result: Integer digits with optional negative sign. | 1234 ("D") -> 1234 |
"E" or "e" | Exponential (scientific) | Result: Exponential notation. | 1052.0329112756 ("E", en-US) -> 1.052033E+003 |
"F" or "f" | Fixed-point | Result: Integral and decimal digits with optional negative sign. | 1234.567 ("F", en-US) -> 1234.57 |
"G" or "g" | General | Result: The most compact of either fixed-point or scientific notation. | -123.456 ("G", en-US) -> -123.456 |
"N" or "n" | Number | Result: Integral and decimal digits, group separators, and a decimal separator with optional negative sign. | 1234.567 ("N", en-US) -> 1,234.57 |
"P" or "p" | Percent | Result: Number multiplied by 100 and displayed with a percent symbol. | 1 ("P", en-US) -> 100.00 % |
"R" or "r" | Round-trip | Result: A string that can round-trip to an identical number. | 123456789.12345678 ("R") -> 123456789.12345678 |
"X" or "x" | Hexadecimal | Result: A hexadecimal string. | 255 ("X") -> FF |
0 Comments