Skip to content

Series

Reached from Series on Query configuration.

Settings

NameRequired

Type
Text

The series name. This is used to display a legend in the plots.

Object Type

Type
M-Files object type

This setting has no description in the application yet.

Class

Type
M-Files class

This setting has no description in the application yet.

Where

Type
Search conditions JA

Search conditions to filter the objects in this series.

Indirect Relation

Type
M-Files property

The property used to find objects that are indirectly related to the current object.

Selected Properties

Type
List of Selected property

The properties to select from the objects. Each property used in split, sorting, and aggregation needs to be defined here.

Settings on each entry — 2 of them

Split Columns

Type
Text

The columns to split this series into sub-series by.

Sort Direction

Type
One of a list

The kind of sorting that should be applied.

  • Ascending
  • Descending

Sort Column

Type
Text

The column to sort the data by.

Aggregation

Type
One of a list
Default
Count

The aggregation to apply to the data. Default: Count.

  • Count
  • Sum
  • Mean

Group Columns

Type
Text

One or more columns to group by. Multiple columns should be separated by a comma.

Round DateTime Columns

Type
Text

One or more datetime columns to round, if necessary. Multiple columns should be separated by a comma.

Round DateTime Unit

Type
One of a list

The rounding time unit. For example, rounding to the nearest week will convert datetimes to the Monday of the week that they belong to.

  • Minute
  • Hour
  • Day
  • Week
  • Month
  • Year

Label ColumnRequired

Type
Text

The column to use as the label axis of the plot.

Value ColumnRequired

Type
Text

The column to use as the value axis of the plot.

Generated from CtrlPortals 3.26.9.53.