widget dataset

cardAlign

This sets the widget card row alignment (top | center | bottom | none)

none

top | center | bottom | none

dataset

Here you specify the ID of the project that is to be displayed.

dataSet

The name of dataset which will be used to resolve incomplete vpath

datasetTemplateId

Here you specify the ID of the template that is to be displayed.

all_available_variables

defaultTable

Input the name of the default table to be used by the dataset widget.

response

description

Description (widget header)

directNodeSuffix

Direct to parent node suffix

(Direct only)

exportable

This activates the possibility for the user to download the widget content as a Microsoft Excel (.xslx) file.

true

true | false

headerNumberOfLines

Here you define the number of lines of text that are to be used for the table header

1

hide

Hide item

true | false | pdf | web

hierarchy

Hierarchical field (vpath) - a field to define parent-child relations when building hierarchy (example - accounts:ParentAccountID)

hierarchyColumn

When the property "hierarchy" is enabled, the property "hierarchyColumn" sets the identifier of the hierarchical column. The expand/collapse arrows for the hierarchy will be displayed in this column.

hierarchyFilters

A list of filter names to ignore for the columns with the filterable property set to false.

hierarchyView

When the property "hierarchy" is enabled, the property "hierarchyView" specifies whether the table is to use hierarchical view instead of flat view.

true

true | false

ignoredTables

This defines a list of any tables that are to be hidden from the user (string list).

ignoreFilters

A list of filter names to ignore. Container name can be used to ignore group of filters (e.g name of layout area)

ignoreFiscalCalendar

This allows you to use standard calendar instead of fiscal one

true | false

ignoreWeights

Use this property to specify any weights that have been defined but are to be ignored at this time. If the list contains multiple items, separate the items with comma.

inHierarchy

This must be a vpath expression. This property influences how the primary key filter is applied based on url parameters. If this property is not specified then only entries with the exact primary key match will be displayed. If it is specified then entries with the exact primary key match, and entries which match the primary keys of all children of the related record, will be displayed in the list.

label

Label (widget header)

navigateDirectNodeTo

Input the name of the page that is to be navigated to when the user clicks the direct node link.

navigateTo

Page to navigate to or a cross-document link entity

paginationType

Specifies pagination type for table.

infiniteScroll

infiniteScroll | paging | none

record

The name of the filters for individual record selection

rowsPerPage

Specifies the number of rows per page options available for the pager select (the list of integers, e.g. 20, 30, 40). Applied with paginationType = paging.

20,50,100

showCodeLabelSelector

false

true | false

showCountInLabel

true

true | false

showDirectNodes

Show direct to parent nodes

false

true | false

showHeader

Specifies whether the column header is to be displayed.

true

true | false

showInvalidAnswerCodes

Specifies whether invalid answers codes are to be displayed.

false

true | false

showTotals

Specifies whether or not the totals row for the table is to be displayed. To redefine the default formula for a specific column, you can specify the custom totalExpression property for that column.

false

true | false

showWidgetHeader [Beta]

Shows widget header. True by default.

true | false

size

This defines the size of the widget when it is displayed on the Dashboard.

small

small | medium | halfwidth | large

skip

The number of items (starting from the first item) that are to be ignored when fetching data.

0

sortColumn

Specifies which column the list is to be sorted by. Input the column ID.

sortOrder

Specifies the sorting order for the list.

ascending

stretchColumns

Here you can specify that any columns without a defined width are to be stretched such that the table fills the entire table width

false

true | false

table

The name of the table (alias) for the widget to work with

take

The number of items to be fetched for one request.

20

useOnlySources

This defines the sources used by the widget to fetch data from.

useWeights

This property holds a list of the weights that are to be used by default.

via

Table(s) for join path conflict resolution

viaStrategy

Join path conflict resolution strategy

default | shortest

widgetVariant [Beta]

Widget variant

default | subtle | emphasised

select

Selector allows you to select option and exposes property 'selected' which can be referenced from any place

access rules

This is a set of rules used to limit access to particular resources (a page, a widget etc). The rules are joined by logical AND, meaning all the rules must be true for the resource to be shown.

infobox

This is widget documentation; information about the widget that is provided by the dashboard designer to the end report viewer. This allows the designer to add custom content for the widget "info" to provide the user with information necessary to understand the visualisation, type of analysis performed, data, etc. for example details about the risk model applied in the Risk assessment.

toolbar

The Toolbar widget is typically used to highlight key information in a simple text format and a selector.

suppressRule

Suppression criteria for a widget

config optimization

Options for optimization

filter expression

Expression filter

overrideFilter date

This allows variables for a date filter to be redefined

overrideFilter level

This allows a level for a filter to be redefined

scope reportingPeriod

Changes the reporting period from default / selected in the filter to different one

scope reportingHierarchy

Changes the reporting hierarchy nodes to be used from default/selected in filter to different one

scope filter

Changes applied filter to to different one

propagateFilter

This action requests Data Engine to automatically apply a filter to a dependent (target) level when a source level is filtered

column value

This object defines a standard way of displaying a value column. You can override the formatting to change the look and feel as required by adding properties. You can add as many columns as required; each must have a unique name.

column valueIcon

This object provides a standard way of displaying a value icon column. You can override the formatting to change the look and feel as required.

column icon

This object defines a standard way of displaying an icon column. You can override the formatting to change the look and feel as required.

column link

This object provides a standard way of displaying a link. You can override the formatting to change the look and feel as required.

column currency

This object provides a standard way of displaying a currency. The default is $ in short-form; you can override the formatting to set up the look and feel as required by adding properties. You can add as many columns as required; each must have a unique name.

column hierarchy

This object adds a hierarchy column that is filtered by default to only show the parent Level of the hierarchy; the child levels are collapsed. It adds an expand button to allow the user to toggle between the hierarchy and the flat views. Note that the data must be in the form of a hierarchy, and the widget must have the hierarchy property set.

column date

This object provides a standard way of rendering column with formatted date value. The default date formatter applied to this column displays dates in short-form e.g. "17 Jan '17". You can override the default formatting to change the look and feel as required by specifying a custom value for the format property. You can add as many columns as required; each must have a unique name.

column metric

This object defines a standard way of displaying a metrics column. You can override the formatting to change the look and feel as required by adding properties. You can add as many columns as required; each must have a unique name.

column responseRate

This defines the column in which the percentage of surveys that are completed is presented.

column valueWithDetails

This object provides a standard way of displaying a 'value with details' column. You can override the formatting to change the look and feel as required.

column expirationProgress

This object adds a column containing a colored bar for each row in the table, which indicates the current expiry status for that row. E.g. gray for unexpired, orange for nearing expiry, and red for expired.

column response

The response column is a mandatory column type for the recent responses widget. Note that it can also be used in other table-like widgets. A column cell has a configurable header and footer, and a content Block.

column actions

This object contains a set of actions which will be displayed differently depending on whether or not the report is being displayed on a mobile device.

view valueWithDetails

A default view settings for displaying value with a toggle arrow to show or hide details

view comment

This is a preset view configuration for displaying multi-line text, which by default has 3 lines. This view is available as defaultCommentView when you specify the view for a column. You also may define your own view based on this one to redefine default settings. You can have multiple view_comment objects in a report; each object must have a unique name.

view icon

This block defines icon view settings. You can use this configuration block to redefine default icon view settings.

view iconText

This block defines icon view settings. You can use this configuration block to redefine default icon view settings.

view expirationProgress

A preset view configuration for displaying a progress bar to track the current date related to the expiry date. Note that this property will normally be unnecessary unless you want to redefine some default settings.

view camelCSS

This is a preset type of view that allows you to style an item or text in a tile with cascading style sheets (CSS) using camelCase. Camel case is the practice of writing compound words such that each word or abbreviation in the middle of the phrase begins with a capital letter, for example camelCase.

view metricWithChange

This item creates a colored tile with a centered, colored digit of predefined width inside it. The tile is used to present metric data, and includes an arrow (up or down) or a flat icon located to the right of the digit to indicate how the value has changed from the previous period.

view link

A view that renders link (does not apply any wrapping)

view metric

This item creates a colored tile with a centered, colored digit of predefined width inside it. The tile is used to present metric data, and includes an arrow (up or down) or a flat icon located to the right of the digit to indicate how the value has changed from the previous period.

view value

value item

view html

This view renders HTML.

view comparativeStatistic