Skip to main content

Keyword: Chart

#EN #Keyword #Charts

What is the keyword to use?

In order to create a chart visual, please use one of the following keywords:

Description

Keyword to Use

Line chart

linechart

Bar chart

barchart

Pie chart

piechart


Why use this keyword?

With this control, you will be able to:

  • Create a line, bar or pie chart that displays as an image the statistics based on selected settings

    • As a field or column, create a chart visual to display statistics based on entire columns, using specific fields as criteria for limits


How to use this keyword?

As a FIELD

Using columns A, B and C in the Excel spreadsheet, you can create a field.

  • Column A will be used for the TITLE

    • The title will be displayed to add a description regarding your input;

  • Column B will be used for the KEYWORD

    • The keyword defines what the field will be used for;

  • Column C will be used for the VALIDATION RULE(S)

Here is an example:

Here is how it displays in the application:

Bar chart

What it looks like on the form:

What it looks like when opened:

Line chart

What it looks like on the form:

What it looks like when opened:

Pie chart

What it looks like on the form:

What it looks like when opened:


As a COLUMN

This feature can't be used in a column.


Validation exceptions

While using this feature, you might encounter some error messages.

Error message

Reason

"There is insufficient or missing data for the X and/or Y axis and the chart cannot be generated"

The targeted column(s) are either empty or don't have enough data to generate statistics

"Impossible to convert the data in a numeric format to display the associated value and the chart cannot be generated"

The targeted column(s) are of a type that is not supported for the type of visual placement they are placed in


You can change their X/Y positions to test if it works better too

"The limit of 100 bars for this type of chart has been reached and the chart cannot be generated"

The data used for the chart creates more than 100 bars and the visual cannot be generated for this reason

"There are invalid or missing parameters and the chart cannot be generated"

Depending on the chart, it could be:

  • Missing column_name

  • Missing x and/or y

  • Duplicated parameter

  • Incomplete parameter


Available validation rules for this keyword

STATE CHANGE

INVALIDITY (LIMITS)

None.

AUTOMATION

None.

FORMULAS

Did this answer your question?