Measure, Dimension and Column Settings - Revision history

Ollvihe: /* Special values */

2026-04-04T14:57:20Z

Special values

← Older revision		Revision as of 14:57, 4 April 2026
Line 15:		Line 15:

	== Special values ==		== Special values ==
	There are special customized labels available for the following values: null, empty string, boolean true, and boolean false~~. Special values are~~:		There are special customized labels available for the following values: null, empty string, boolean true, and boolean false:
	* '''Show for null value''': When the data point value is null, the text defined in this field is shown. By default empty text.		* '''Show for null value''': When the data point value is null, the text defined in this field is shown. By default empty text.
	* '''Show for empty string''': When the data point value is an empty string , the text defined in this field is shown. By default text ''(empty)''.		* '''Show for empty string''': When the data point value is an empty string , the text defined in this field is shown. By default text ''(empty)''.

Ollvihe: /* Special values */

2026-04-04T14:56:27Z

Special values

← Older revision		Revision as of 14:56, 4 April 2026
Line 15:		Line 15:

	== Special values ==		== Special values ==
	~~It's possible to configure that certain~~ special values (null, empty string, true, false~~) are shown in certain ways. Defining textual representations for these special values is a better practice than customizing the expression to show certain texts~~. Special values are:		There are special customized labels available for the following values: null, empty string, boolean true, and boolean false. Special values are:
	* '''Show for null value''': When ~~an expression gives a~~ null ~~value~~, the text defined in this field is shown. By default empty text.		* '''Show for null value''': When the data point value is null, the text defined in this field is shown. By default empty text.
	* '''Show for empty string''': When ~~an expression gives~~ an empty string ~~value~~, the text defined in this field is shown. By default ''(empty)''.		* '''Show for empty string''': When the data point value is an empty string , the text defined in this field is shown. By default text ''(empty)''.
	* '''Show for boolean true''': When ~~an expression gives~~ a boolean ~~value~~ ''true'', the text defined in this field is shown. By default ''Yes''.		* '''Show for boolean true''': When the data point value is a boolean ''true'', the text defined in this field is shown. By default text ''Yes''.
	* '''Show for boolean false''': When ~~an expression gives~~ a boolean ~~value~~ ''false'', the text defined in this field is shown. By default ''No''.		* '''Show for boolean false''': When the data point value is a boolean ''false'', the text defined in this field is shown. By default text ''No''.

			It's also possible to write a custom expression that returns the special string values but the above configuration is easier and provides better performance when the customization need is only for these labels.

	== Advanced settings ==		== Advanced settings ==

TeeHiet: TK-62256

2025-12-15T08:46:55Z

TK-62256

← Older revision		Revision as of 08:46, 15 December 2025
Line 80:		Line 80:
	*'''Visualize list items with colors''': Shows an improved visualization for lists where each item is highlighted with a color from the color palette. Colors are assigned in the order items appear in the table. When all colors in the color palette are assigned, next colors are assigned from the beginning of the color palette. Only available for Table visualization. Only available for data type List. The reference value defines fixed width for the items as pixels. The reference value is optional and when not defined, each item takes the entire text space.		*'''Visualize list items with colors''': Shows an improved visualization for lists where each item is highlighted with a color from the color palette. Colors are assigned in the order items appear in the table. When all colors in the color palette are assigned, next colors are assigned from the beginning of the color palette. Only available for Table visualization. Only available for data type List. The reference value defines fixed width for the items as pixels. The reference value is optional and when not defined, each item takes the entire text space.
	*'''Compensate case sampling''': Multiplies numerical values with a factor that tries to compensate the effect of value decreasing due to case sampling. The factor is calculated as a filtered case count (when taking into account all filter rules in the chart) divided by the cases sample size. If the factor is less than 1, it's not applied. This is because then the sample size is larger than the number of cases and thus the sampling does not reduce the number of cases. Available only for numerical measures. Regarding flowcharts, this setting is available only for the Snowflake flowchart.		*'''Compensate case sampling''': Multiplies numerical values with a factor that tries to compensate the effect of value decreasing due to case sampling. The factor is calculated as a filtered case count (when taking into account all filter rules in the chart) divided by the cases sample size. If the factor is less than 1, it's not applied. This is because then the sample size is larger than the number of cases and thus the sampling does not reduce the number of cases. Available only for numerical measures. Regarding flowcharts, this setting is available only for the Snowflake flowchart.
			*'''Top Insights contributor''': Only available for the table visualization. Shows the Snowflake Top Insights contributor in a user-friendly format and hierarchy order. This Statistical calculation is only available when the root is Snowflake Top Insights and column is the Top Insights contributor or a custom expression. The Reference value for statistical calculation defines the zero-based index for the column to sort the rows within each level in the hierarchy. If the reference value is not defined, rows are sorted by the contributor rules as follows:
			** Contributors with less rules are first.
			** Contributor comparison type in the following order: equal, not equal, greater than, greater than or equal, less than, less than or equal.
			** Column name, e.g., case/event attribute name.
			** Column value, e.g., case attribute value.

	=== Applying statistical calculations in groups ===		=== Applying statistical calculations in groups ===

TeeHiet: TK-57100

2025-05-14T06:52:25Z

TK-57100

← Older revision		Revision as of 06:52, 14 May 2025
Line 79:		Line 79:
	*'''Nonconformance reason formatting''': Shows the json formatted nonconformance reasons (provided by the Snowflake ConformanceViolationsFlows function) as user-readable text. When a reference value of zero is used, the nonconformance reason is formatted as html where the event type names are bolded. When a reference value of one is used, the conconformance reasons are shown as pure text.		*'''Nonconformance reason formatting''': Shows the json formatted nonconformance reasons (provided by the Snowflake ConformanceViolationsFlows function) as user-readable text. When a reference value of zero is used, the nonconformance reason is formatted as html where the event type names are bolded. When a reference value of one is used, the conconformance reasons are shown as pure text.
	*'''Visualize list items with colors''': Shows an improved visualization for lists where each item is highlighted with a color from the color palette. Colors are assigned in the order items appear in the table. When all colors in the color palette are assigned, next colors are assigned from the beginning of the color palette. Only available for Table visualization. Only available for data type List. The reference value defines fixed width for the items as pixels. The reference value is optional and when not defined, each item takes the entire text space.		*'''Visualize list items with colors''': Shows an improved visualization for lists where each item is highlighted with a color from the color palette. Colors are assigned in the order items appear in the table. When all colors in the color palette are assigned, next colors are assigned from the beginning of the color palette. Only available for Table visualization. Only available for data type List. The reference value defines fixed width for the items as pixels. The reference value is optional and when not defined, each item takes the entire text space.
	*'''Compensate case sampling''': Multiplies numerical values with a factor that tries to compensate the effect of value decreasing due to case sampling. The factor is calculated as a filtered case count (when taking into account all filter rules in the chart) divided by the cases sample size. If the factor is less than 1, it's not applied. This is because then the sample size is larger than the number of cases and thus the sampling does not reduce the number of cases. Available only for numerical measures.		*'''Compensate case sampling''': Multiplies numerical values with a factor that tries to compensate the effect of value decreasing due to case sampling. The factor is calculated as a filtered case count (when taking into account all filter rules in the chart) divided by the cases sample size. If the factor is less than 1, it's not applied. This is because then the sample size is larger than the number of cases and thus the sampling does not reduce the number of cases. Available only for numerical measures. Regarding flowcharts, this setting is available only for the Snowflake flowchart.

	=== Applying statistical calculations in groups ===		=== Applying statistical calculations in groups ===

TeeHiet: TK-57100

2025-05-14T06:47:58Z

TK-57100

← Older revision		Revision as of 06:47, 14 May 2025
Line 79:		Line 79:
	*'''Nonconformance reason formatting''': Shows the json formatted nonconformance reasons (provided by the Snowflake ConformanceViolationsFlows function) as user-readable text. When a reference value of zero is used, the nonconformance reason is formatted as html where the event type names are bolded. When a reference value of one is used, the conconformance reasons are shown as pure text.		*'''Nonconformance reason formatting''': Shows the json formatted nonconformance reasons (provided by the Snowflake ConformanceViolationsFlows function) as user-readable text. When a reference value of zero is used, the nonconformance reason is formatted as html where the event type names are bolded. When a reference value of one is used, the conconformance reasons are shown as pure text.
	*'''Visualize list items with colors''': Shows an improved visualization for lists where each item is highlighted with a color from the color palette. Colors are assigned in the order items appear in the table. When all colors in the color palette are assigned, next colors are assigned from the beginning of the color palette. Only available for Table visualization. Only available for data type List. The reference value defines fixed width for the items as pixels. The reference value is optional and when not defined, each item takes the entire text space.		*'''Visualize list items with colors''': Shows an improved visualization for lists where each item is highlighted with a color from the color palette. Colors are assigned in the order items appear in the table. When all colors in the color palette are assigned, next colors are assigned from the beginning of the color palette. Only available for Table visualization. Only available for data type List. The reference value defines fixed width for the items as pixels. The reference value is optional and when not defined, each item takes the entire text space.
			*'''Compensate case sampling''': Multiplies numerical values with a factor that tries to compensate the effect of value decreasing due to case sampling. The factor is calculated as a filtered case count (when taking into account all filter rules in the chart) divided by the cases sample size. If the factor is less than 1, it's not applied. This is because then the sample size is larger than the number of cases and thus the sampling does not reduce the number of cases. Available only for numerical measures.

	=== Applying statistical calculations in groups ===		=== Applying statistical calculations in groups ===

Ollvihe: /* Statistical calculations */

2025-05-11T21:48:57Z

Statistical calculations

← Older revision		Revision as of 21:48, 11 May 2025
Line 34:		Line 34:
	Statistical calculations contain various useful conversions and adjustments that may be needed in measures, dimensions and columns. Each statistical calculation is applied to a specific measure, dimension or column, so make sure to choose the right one where to apply the statistical calculation. Several statistical calculations can be selected for the same measure, dimension or column, and they are applied in the order they are defined in the list. In addition, dimension statistical calculations are applied before the measure statistical calculations. Certain statistical calculations can only be applied to specific column data types, so only the applicable statistical calculations are shown. Certain combinations of statistical calculations are not possible, so when selecting statistical calculations, some other statistical calculations may automatically be deselected.		Statistical calculations contain various useful conversions and adjustments that may be needed in measures, dimensions and columns. Each statistical calculation is applied to a specific measure, dimension or column, so make sure to choose the right one where to apply the statistical calculation. Several statistical calculations can be selected for the same measure, dimension or column, and they are applied in the order they are defined in the list. In addition, dimension statistical calculations are applied before the measure statistical calculations. Certain statistical calculations can only be applied to specific column data types, so only the applicable statistical calculations are shown. Certain combinations of statistical calculations are not possible, so when selecting statistical calculations, some other statistical calculations may automatically be deselected.

	If the second dimension is defined, the statistical calculations are performed in [[#Applying_statistical_calculations_in_groups\|groups]] by the second dimension values.		If the second dimension is defined, the statistical calculations are performed in [[#Applying_statistical_calculations_in_groups\|groups]] by the second dimension values, unless otherwise specified.

	The following statistical calculation options are available:		The following statistical calculation options are available:
Line 81:		Line 81:

	=== Applying statistical calculations in groups ===		=== Applying statistical calculations in groups ===
	Some statistical calculations can be applied groups, meaning that they are applied for each group separately instead of the entire dataset. When applying in groups, the groups are determined by the second dimension values. Grouping is applied when the ~~statistical calculation configuration has~~ "applyInGroups"~~=true. This needs~~ to ~~be specified in~~ the chart configuration~~. Example~~:		Some statistical calculations can be applied groups, meaning that they are applied for each group separately instead of the entire dataset. When applying in groups, the groups are determined by the second dimension values. Grouping is applied when the second dimension is defined and it's possible to disable the grouping by adding "applyInGroups" ''false'' to the chart configuration:
	<pre>		<pre>
	{		{
	"type": "removeRepeatingValues",		"type": "removeRepeatingValues",
	"applyInGroups": ~~true~~		"applyInGroups": false
	}		}
	</pre>		</pre>

Ollvihe: /* Statistical calculations */

2025-05-11T21:46:27Z

Statistical calculations

← Older revision		Revision as of 21:46, 11 May 2025
Line 32:		Line 32:

	== Statistical calculations ==		== Statistical calculations ==
	Statistical calculations contain various useful conversions and adjustments that may be needed in measures, dimensions and columns. Each statistical calculation is applied to a specific measure, dimension or column, so make sure to choose the right one where to apply the statistical calculation. Several statistical calculations can be selected for the same measure, dimension or column, and they are applied in the order they are defined in the list. In addition, dimension statistical calculations are applied before the measure statistical calculations. Certain statistical calculations can only be applied to specific column data types, so only the applicable statistical calculations are shown~~. If the second dimension is defined, the statistical calculations are performed for each unique dimension value separately~~. Certain combinations of statistical calculations are not possible, so when selecting statistical calculations, some other statistical calculations may automatically be ~~unselected~~.		Statistical calculations contain various useful conversions and adjustments that may be needed in measures, dimensions and columns. Each statistical calculation is applied to a specific measure, dimension or column, so make sure to choose the right one where to apply the statistical calculation. Several statistical calculations can be selected for the same measure, dimension or column, and they are applied in the order they are defined in the list. In addition, dimension statistical calculations are applied before the measure statistical calculations. Certain statistical calculations can only be applied to specific column data types, so only the applicable statistical calculations are shown. Certain combinations of statistical calculations are not possible, so when selecting statistical calculations, some other statistical calculations may automatically be deselected.

			If the second dimension is defined, the statistical calculations are performed in [[#Applying_statistical_calculations_in_groups\|groups]] by the second dimension values.

	The following statistical calculation options are available:		The following statistical calculation options are available:

Ollvihe: /* Applying statistical calculations in groups */

2025-05-11T21:43:07Z

Applying statistical calculations in groups

← Older revision		Revision as of 21:43, 11 May 2025
Line 79:		Line 79:

	=== Applying statistical calculations in groups ===		=== Applying statistical calculations in groups ===
	Some statistical calculations can be applied groups, meaning that ~~the algorithm is~~ applied for each group separately instead of the entire dataset. When applying in groups, the groups are determined by the second dimension values. ~~Groupping~~ is applied when the statistical calculation configuration has "applyInGroups"=true. This needs to be specified in the chart configuration.		Some statistical calculations can be applied groups, meaning that they are applied for each group separately instead of the entire dataset. When applying in groups, the groups are determined by the second dimension values. Grouping is applied when the statistical calculation configuration has "applyInGroups"=true. This needs to be specified in the chart configuration. Example:

	Example:
	<pre>		<pre>
	{		{

Ollvihe: /* Statistical calculations */

2025-05-11T21:42:10Z

Statistical calculations

@@ Line 77: / Line 77: @@
 *'''Nonconformance reason formatting''': Shows the json formatted nonconformance reasons (provided by the Snowflake ConformanceViolationsFlows function) as user-readable text. When a reference value of zero is used, the nonconformance reason is formatted as html where the event type names are bolded. When a reference value of one is used, the conconformance reasons are shown as pure text.
 *'''Visualize list items with colors''': Shows an improved visualization for lists where each item is highlighted with a color from the color palette. Colors are assigned in the order items appear in the table. When all colors in the color palette are assigned, next colors are assigned from the beginning of the color palette. Only available for Table visualization. Only available for data type List. The reference value defines fixed width for the items as pixels. The reference value is optional and when not defined, each item takes the entire text space.
 == Other settings ==

Ollvihe: /* Advanced settings */

2025-03-06T18:59:22Z

Advanced settings

← Older revision		Revision as of 18:59, 6 March 2025
Line 25:		Line 25:
	* '''Calculate measure for''': Measure can be calculated for ''each dimension separately'' (the default option) which is the normal dimensioning behavior. It's also possible to ignore the dimensioning for this measure and calculate the measure for the ''currently filtered data'' (i.e. the measure is calculated for the entire dataset that the chart is based on). Furthermore, it's also possible to ignore filters and calculate the measure value for the ''entire model data''. This setting is only available for measures. This setting is not available for the Snowflake chart.		* '''Calculate measure for''': Measure can be calculated for ''each dimension separately'' (the default option) which is the normal dimensioning behavior. It's also possible to ignore the dimensioning for this measure and calculate the measure for the ''currently filtered data'' (i.e. the measure is calculated for the entire dataset that the chart is based on). Furthermore, it's also possible to ignore filters and calculate the measure value for the ''entire model data''. This setting is only available for measures. This setting is not available for the Snowflake chart.
	* '''Variable name''': Defines name for the variable containing this measure value. The variable can then be used in all measures that are below this measure. Variables can be used to define more complex measures (defined using custom measure expression) that consist of other measures (that are defined as variables). In the Snowflake chart, variables can be used with syntax ''Column("variableName")'', and in in-memory chart with syntax ''variableName''. This setting is not available for dimensions, and for columns this setting is available only in the in-memory chart. Spaces cannot be used in variable names.		* '''Variable name''': Defines name for the variable containing this measure value. The variable can then be used in all measures that are below this measure. Variables can be used to define more complex measures (defined using custom measure expression) that consist of other measures (that are defined as variables). In the Snowflake chart, variables can be used with syntax ''Column("variableName")'', and in in-memory chart with syntax ''variableName''. This setting is not available for dimensions, and for columns this setting is available only in the in-memory chart. Spaces cannot be used in variable names.
	* '''Disable filtering''': ~~Disables~~ filtering for individual dimension or column. For Highcharts based visualization, clicking datapoints don't create filter rules for those dimensions or columns where filtering is disabled. For ~~datagrid~~ visualization, clicking the datagrid column corresponding to the dimension or column where filtering is disabled, doesn't create a filter rule. ~~Shown~~ only for dimensions and columns and when ~~datagrid~~ or ~~Highcharts~~ based visualization is selected.		* '''Disable filtering''': If you don't need filtering for an individual dimension or column while it's needed for others, this checkbox can be used to disable it for one dimension or column. For Highcharts based visualization, clicking datapoints don't create filter rules for those dimensions or columns where filtering is disabled. For table visualization, clicking the datagrid column corresponding to the dimension or column where filtering is disabled, doesn't create a filter rule. Available only for dimensions and columns and when Highcharts or table based visualization is selected.
	* '''Statistical calculations''': Different kind of useful calculations that can be to measure/dimension/columns. Multiple statistical calculations can be applied at the same time. Some calculations require an additional parameter, that is specified in the ''Reference value for statistical calculations'' field. Available statistical calculations are listed in [[#Statistical_calculation_methods\|Statistical calculation methods]].		* '''Statistical calculations''': Different kind of useful calculations that can be to measure/dimension/columns. Multiple statistical calculations can be applied at the same time. Some calculations require an additional parameter, that is specified in the ''Reference value for statistical calculations'' field. Available statistical calculations are listed in [[#Statistical_calculation_methods\|Statistical calculation methods]].
	* '''Reference value for statistical calculations''': This field is used to specify the reference numerical value needed by some of the statistical calculations. Note that there is only one field available, so only one statistical calculation needing a reference value can be used.		* '''Reference value for statistical calculations''': This field is used to specify the reference numerical value needed by some of the statistical calculations. Note that there is only one field available, so only one statistical calculation needing a reference value can be used.