Charts

Common Properties

This section lists the properties that are common to the Chart components.

View

The View tab lets you see the views name and type and also set the initial visibility and z-index.

The Image Server provides a static image of your view.

The Show Image Server Url option allows you to set the image height and width, and the cache duration.

You can copy and paste this URL anywhere else (for example, in Adhoc Reports) to display the image.

Action Bar

  • Show action bar: Determines whether to display the action bar or not.

  • Title: Fill in the title.

  • Show info button: Fill in the information and customise its format. On clicking, the information you have entered will display in a text field, guiding the user on how to proceed.

  • Show render button: A render button will display, which allows you to render into the desired output format, including HTML, PDF, XLSX and CSV. You can choose from the following output targets: Browser, Repository and Mail. You can also specify the render details, including page size and orientation (portrait or landscape).

  • Show filter button: A filter button will display. On clicking, a filter editor will open.

  • Show maximise button: A maximise button will display allowing you to maximise or restore the component in the browser.

Data

  • URL: On selecting the Source, the related URL will automatically appear.

  • Source: Select from universe, view or embedded. A window will pop up, showing the available tables under universe, or the available views under the view options, with an option to use all data from that view or only the selected items, or display the schema under the embedded option.

  • Parameters: After the Source and URL are set, parameters will display (if any).

  • Javascript: Enter any Javascript code that needs to be run.

Filter

  • Add: In the Add Filter window, you can specify the field name, filter type and condition, as well as edit or delete the views. Refer to Table 7.1, “Filter Types”.

Table 7.1. Filter Types

Filter TypeDescription
less-thanThis will show the records which are less than the value in the Condition field.
more-thanThis will show the records which are more than the value in the Condition field.
equalThis will show the records which are equal to the value in the Condition field.
equal-nullThis will not show any records.
not-less-thanThis will show the records which are not less than the value in the Condition field.
not-more-thanThis will show the records which are not more than the value in the Condition field.
not-equalThis will show the records which are not equal to the value in the Condition field.
not-equal-nullThis will show all the records which are not null records.
less-than-or-equalThis will show the records which are less than or equal to the value in the Condition field.
more-than-or-equalThis will show the records which are more than or equal to the value in the Condition field.
in-datasetClick the checkbox next to the Condition field. Select a view and column, or a universe and a table. After you make your selection, the filter condition details will automatically display in the Condition field. Click OK and click Apply. Records in the dataset will display.
not-in-datasetClick the checkbox next to the Condition field. Select a view and column, or a universe and a table. After you make your selection, the filter condition details will automatically display in the Condition field. Click OK and click Apply. Records not in the dataset will display.
is-trueRecords that match the filter condition specified in the Condition field, will display.
is-falseRecords that do NOT match the filter condition specified in the Condition field, will display.

Area Chart

Area charts are used to represent cumulated totals using numbers or percentages, over time. Use the area chart for showing trends over time among related attributes.

View: See the section called “View”

Actionbar: See the section called “Action Bar”

Data: See the section called “Data”

ElxArea

  • Data: Specifies the data sort order - either Ascending or Descending. In addition, the parameters for the Key and X and Y values can be selected. The Y value can be of various functions.

  • General Properties: Allows you to set the padding, the speed of the animation and the palette colours.

  • Background: Allows you to set the background properties such as border colour, width, radius and opacity.

  • Title: Enter a title for the chart and set its various properties such as position, alignment, rotation, padding and gap.

  • Subtitle: Enter a subtitle for the chart and set its various properties such as position, alignment, rotation, padding and gap, for each of the four directions - North, South, East and West.

  • Legend: Set the legend and its properties.

  • Tooltip: Set whether to hide or show tool tips. In addition, set the properties of the tool tip such as the font and background border colour and opacity.

  • Horizontal Axis: Set the properties of the horizontal axis such as padding, gap, and the format and font for the labels.

  • Vertical Axis: Set the properties of the vertical axis such as padding, gap, and the format and font for the labels.

  • Stripe: Set whether to hide or show stripes. In addition, set the properties of the stripe such as the font and background border colour and opacity.

  • Area: Set the properties of the chart area such as the opacity and border width.

  • Point: Set the properties of points such as the font, radius and opacity.

Filter: See the section called “Filter”

Bar Chart

A bar chart uses either horizontal or vertical bars to show comparisons among categories. One axis of the chart shows the specific categories being compared, and the other axis represents a discrete value.

View: See the section called “View”

Actionbar: See the section called “Action Bar”

Data: See the section called “Data”

ElxBar

  • Data: Specifies the data sort order - either Ascending or Descending. In addition, the parameters for the Key and X and Y values can be selected. The Y value can be of various functions.

  • General Properties: Allows you to set the padding, the speed of the animation and the palette colours.

  • Background: Allows you to set the background properties such as border colour, width, radius and opacity.

  • Title: Enter a title for the chart and set its various properties such as position, alignment, rotation, padding and gap.

  • Subtitle: Enter a subtitle for the chart and set its various properties such as position, alignment, rotation, padding and gap, for each of the four directions - North, South, East and West.

  • Legend: Set the legend and its properties.

  • Tooltip: Set whether to hide or show tool tips. In addition, set the properties of the tool tip such as the font and background border colour and opacity.

  • Horizontal Axis: Set the properties of the horizontal axis such as padding, gap, and the format and font for the labels.

  • Vertical Axis: Set the properties of the vertical axis such as padding, gap, and the format and font for the labels.

  • Stripe: Set whether to hide or show stripes. In addition, set the properties of the stripe such as the font and background border colour and opacity.

  • Area: Set the properties of the chart area such as the opacity and border width.

  • Point: Set the properties of points such as the font, radius and opacity.

Filter: See the section called “Filter”

Column Chart

A column chart is a graphical representation of data with rectangular bars of lengths that are proportional to the magnitudes or frequencies of what each bar signifies. It is used to show a difference over a period of time or even illustrate a comparison between items. It is similar to a bar chart but with the bars plotted vertically.

View: See the section called “View”

Actionbar: See the section called “Action Bar”

Data: See the section called “Data”

ElxColumn

  • Data: Specifies the data sort order - either Ascending or Descending. In addition, the parameters for the Key and X and Y values can be selected. The Y value can be of various functions.

  • General Properties: Allows you to set the padding, the speed of the animation and the palette colours.

  • Background: Allows you to set the background properties such as border colour, width, radius and opacity.

  • Title: Enter a title for the chart and set its various properties such as position, alignment, rotation, padding and gap.

  • Subtitle: Enter a subtitle for the chart and set its various properties such as position, alignment, rotation, padding and gap, for each of the four directions - North, South, East and West.

  • Legend: Set the legend and its properties.

  • Tooltip: Set whether to hide or show tool tips. In addition, set the properties of the tool tip such as the font and background border colour and opacity.

  • Horizontal Axis: Set the properties of the horizontal axis such as padding, gap, and the format and font for the labels.

  • Vertical Axis: Set the properties of the vertical axis such as padding, gap, and the format and font for the labels.

  • Stripe: Set whether to hide or show stripes. In addition, set the properties of the stripe such as the font and background border colour and opacity.

  • Area: Set the properties of the chart area such as the opacity and border width.

  • Point: Set the properties of points such as the font, radius and opacity.

Filter: See the section called “Filter”

Line Chart

A line chart displays information as a series of data points called 'markers' connected by straight line segments. A line chart is usually used to visualise a trend in data over intervals of time – a time series – thus the line is often drawn chronologically.

View: See the section called “View”

Actionbar: See the section called “Action Bar”

Data: See the section called “Data”

ElxLine

  • Data: Specifies the data sort order - either Ascending or Descending. In addition, the parameters for the Key and X and Y values can be selected. The Y value can be of various functions.

  • General Properties: Allows you to set the padding, the speed of the animation and the palette colours.

  • Background: Allows you to set the background properties such as border colour, width, radius and opacity.

  • Title: Enter a title for the chart and set its various properties such as position, alignment, rotation, padding and gap.

  • Subtitle: Enter a subtitle for the chart and set its various properties such as position, alignment, rotation, padding and gap, for each of the four directions - North, South, East and West.

  • Legend: Set the legend and its properties.

  • Tooltip: Set whether to hide or show tool tips. In addition, set the properties of the tool tip such as the font and background border colour and opacity.

  • Horizontal Axis: Set the properties of the horizontal axis such as padding, gap, and the format and font for the labels.

  • Vertical Axis: Set the properties of the vertical axis such as padding, gap, and the format and font for the labels.

  • Stripe: Set whether to hide or show stripes. In addition, set the properties of the stripe such as the font and background border colour and opacity.

  • Area: Set the properties of the chart area such as the opacity and border width.

  • Point: Set the properties of points such as the font, radius and opacity.

Filter: See the section called “Filter”

Pie Chart

A pie chart is a circular chart divided into sectors, each depicting a numerical proportion. In a pie chart, the arc length of each sector, is proportional to the quantity it represents.

Pie charts are generally used to show percentage or proportional data and usually the percentage represented by each category is provided next to the corresponding slice of pie.

View: See the section called “View”

Actionbar: See the section called “Action Bar”

Data: See the section called “Data”

ElxPie

  • Data: Specifies the data sort order - either Ascending or Descending. In addition, the parameters for the Key and X and Y values can be selected. The Y value can be of various functions.

  • General Properties: Allows you to set the padding, the speed of the animation and the palette colours.

  • Background: Allows you to set the background properties such as border colour, width, radius and opacity.

  • Title: Enter a title for the chart and set its various properties such as position, alignment, rotation, padding and gap.

  • Subtitle: Enter a subtitle for the chart and set its various properties such as position, alignment, rotation, padding and gap, for each of the four directions - North, South, East and West.

  • Legend: Set the legend and its properties.

  • Tooltip: Set whether to hide or show tool tips. In addition, set the properties of the tool tip such as the font and background border colour and opacity.

  • Horizontal Axis: Set the properties of the horizontal axis such as padding, gap, and the format and font for the labels.

  • Vertical Axis: Set the properties of the vertical axis such as padding, gap, and the format and font for the labels.

  • Stripe: Set whether to hide or show stripes. In addition, set the properties of the stripe such as the font and background border colour and opacity.

  • Area: Set the properties of the chart area such as the opacity and border width.

  • Point: Set the properties of points such as the font, radius and opacity.

Filter: See the section called “Filter”

Scatter Chart

A scatter uses Cartesian coordinates to display values for two variables for a set of data. The data is displayed as a collection of points, each having the value of one variable determining the position on the horizontal axis and the value of the other variable determining the position on the vertical axis.

A scatter chart is used when a variable exists that is below the control of the experimenter. If a parameter exists that is systematically incremented and/or decremented by the other, it is called the control parameter or independent variable and is customarily plotted along the horizontal axis. The measured or dependent variable is customarily plotted along the vertical axis.

The scatter chart can suggest various kinds of correlations between variables with a certain confidence interval.

View: See the section called “View”

Actionbar: See the section called “Action Bar”

Data: See the section called “Data”

ElxScatter

  • Data: Specifies the data sort order - either Ascending or Descending. In addition, the parameters for the Key and X, Y and R values can be selected. The X, Y and R values can be of various functions.

  • General Properties: Allows you to set the padding, the speed of the animation and the palette colours.

  • Background: Allows you to set the background properties such as border colour, width, radius and opacity.

  • Title: Enter a title for the chart and set its various properties such as position, alignment, rotation, padding and gap.

  • Subtitle: Enter a subtitle for the chart and set its various properties such as position, alignment, rotation, padding and gap, for each of the four directions - North, South, East and West.

  • Legend: Set the legend and its properties.

  • Tooltip: Set whether to hide or show tool tips. In addition, set the properties of the tool tip such as the font and background border colour and opacity.

  • Horizontal Axis: Set the properties of the horizontal axis such as padding, gap, and the format and font for the labels.

  • Vertical Axis: Set the properties of the vertical axis such as padding, gap, and the format and font for the labels.

  • Stripe: Set whether to hide or show stripes. In addition, set the properties of the stripe such as the font and background border colour and opacity.

  • Area: Set the properties of the chart area such as the opacity and border width.

  • Point: Set the properties of points such as the font, radius and opacity.

Filter: See the section called “Filter”