Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

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:

  1. From the Eagle Portal main window, click Dashboards.
    You see the Dashboards window displayed in the default view.
  2. Click the Manage drop down menu and select Parts.
    You see the Parts window with all the dashboard parts available to you.
  3. Click New.
    You see the Define window where you can select Define window options, including the part type and fields.
  4. Enter the Part Name and select the Category.
  5. For Select part type, click to select the Chart or the Chart and Data option.
  6. 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.
  7. 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.
  8. Under Chart Options, click to select the chart type and complete the options in the Series dialog box.
  9. 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.
  10. Enter the appropriate information for the other Display window options and click Next.
    You see the Publish window.
  11. Enter the information in the appropriate Publish window options.
  12. Click Finish to save your changes to the dashboard part.
    You see the updated part in the Parts window.
  13. 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.

On this page

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.

All keywords must be entered in upper case.

KeywordDescriptionMultiple Y ValuesFormatting 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 SpecifierNameDescriptionExamples

"C" or "c"

Currency

Result: A currency value.
Supported by: All numeric types.
Precision specifier: Number of decimal digits.
Default precision specifier: Defined in the NumberFormatInfo.CurrencyDecimalDigits Property section of Microsoft's Software Developer Network (MSDN).
For more information, go to The Currency ("C") Format Specifier section of Microsoft's Software Developer Network (MSDN).

123.456 ("C", en-US) -> $123.46
123.456 ("C", fr-FR) -> 123,46 €
123.456 ("C", ja-JP) -> ¥123
-123.456 ("C3", en-US) -> ($123.456)
-123.456 ("C3", fr-FR) -> -123,456 €
-123.456 ("C3", ja-JP) -> -¥123.456

"D" or "d"

Decimal

Result: Integer digits with optional negative sign.
Supported by: Integral types only.
Precision specifier: Minimum number of digits.
Default precision specifier: Minimum number of digits required.
For more information, go to The Decimal ("D") Format Specifier section of Microsoft's Software Developer Network (MSDN).

1234 ("D") -> 1234
-1234 ("D6") -> -001234

"E" or "e"

Exponential (scientific)

Result: Exponential notation.
Supported by: All numeric types.
Precision specifier: Number of decimal digits.
Default precision specifier: 6.
For more information, go to The Exponential ("E") Format Specifier section of Microsoft's Software Developer Network (MSDN).

1052.0329112756 ("E", en-US) -> 1.052033E+003
1052.0329112756 ("e", fr-FR) -> 1,052033e+003
-1052.0329112756 ("e2", en-US) -> -1.05e+003
-1052.0329112756 ("E2", fr_FR) -> -1,05E+003

"F" or "f"

Fixed-point

Result: Integral and decimal digits with optional negative sign.
Supported by: All numeric types.
Precision specifier: Number of decimal digits.
Default precision specifier: Defined in the NumberFormatInfo.NumberDecimalDigits Property section of Microsoft's Software Developer Network (MSDN).
For more information, go to The Fixed-Point ("F") Format Specifier section of Microsoft's Software Developer Network (MSDN).

1234.567 ("F", en-US) -> 1234.57
1234.567 ("F", de-DE) -> 1234,57
1234 ("F1", en-US) -> 1234.0
1234 ("F1", de-DE) -> 1234,0
-1234.56 ("F4", en-US) -> -1234.5600
-1234.56 ("F4", de-DE) -> -1234,5600

"G" or "g"

General

Result: The most compact of either fixed-point or scientific notation.
Supported by: All numeric types.
Precision specifier: Number of significant digits.
Default precision specifier: Depends on numeric type.
For more information, go to The General ("G") Format Specifier section of Microsoft's Software Developer Network (MSDN).

-123.456 ("G", en-US) -> -123.456
123.456 ("G", sv-SE) -> -123,456
123.4546 ("G4", en-US) -> 123.5
123.4546 ("G4", sv-SE) -> 123,5
-1.234567890e-25 ("G", en-US) -> -1.23456789E-25
-1.234567890e-25 ("G", sv-SE) -> -1,23456789E-25

"N" or "n"

Number

Result: Integral and decimal digits, group separators, and a decimal separator with optional negative sign.
Supported by: All numeric types.
Precision specifier: Desired number of decimal places.
Default precision specifier: Defined in the NumberFormatInfo.NumberDecimalDigits Property section of Microsoft's Software Developer Network (MSDN).
For more information, go to The Numeric ("N") Format Specifier section of Microsoft's Software Developer Network (MSDN).

1234.567 ("N", en-US) -> 1,234.57
1234.567 ("N", ru-RU) -> 1 234,57
1234 ("N1", en-US) -> 1,234.0
1234 ("N1", ru-RU) -> 1 234,0
-1234.56 ("N3", en-US) -> -1,234.560
-1234.56 ("N3", ru-RU) -> -1 234,560

"P" or "p"

Percent

Result: Number multiplied by 100 and displayed with a percent symbol.
Supported by: All numeric types.
Precision specifier: Desired number of decimal places.
Default precision specifier: Defined in the NumberFormatInfo.PercentDecimalDigits Property section of Microsoft's Software Developer Network (MSDN).
For more information, go to The Percent ("P") Format Specifier section of Microsoft's Software Developer Network (MSDN).

1 ("P", en-US) -> 100.00 %
1 ("P", fr-FR) -> 100,00 %
-0.39678 ("P1", en-US) -> -39.7 %
-0.39678 ("P1", fr-FR) -> -39,7 %

"R" or "r"

Round-trip

Result: A string that can round-trip to an identical number.
Supported by: Single, Double, and BigInteger. For more information, go to the Single Structure, Double Structure, and BigInteger Structure sections of Microsoft's Software Developer Network (MSDN).
Precision specifier: Ignored.
For more information, go to The Round-trip ("R") Format Specifier section of Microsoft's Software Developer Network (MSDN).

123456789.12345678 ("R") -> 123456789.12345678
-1234567890.12345678 ("R") -> -1234567890.1234567

"X" or "x"

Hexadecimal

Result: A hexadecimal string.
Supported by: Integral types only.
Precision specifier: Number of digits in the result string.
For more information, go to The HexaDecimal ("X") Format Specifier section of Microsoft's Software Developer Network (MSDN).

255 ("X") -> FF
-1 ("x") -> ff
255 ("x4") -> 00ff
-1 ("X4") -> 00FF

  • No labels