Snowflake Chart - Revision history

Ollvihe: Ollvihe moved page Big Data Chart to Snowflake Chart without leaving a redirect

2024-06-13T17:39:37Z

Ollvihe moved page Big Data Chart to Snowflake Chart without leaving a redirect

← Older revision	Revision as of 17:39, 13 June 2024
(No difference)

Ollvihe at 17:39, 13 June 2024

2024-06-13T17:39:26Z

Ollvihe: /* Analyzed objects */

2024-06-13T17:34:49Z

Analyzed objects

← Older revision		Revision as of 17:34, 13 June 2024
Line 87:		Line 87:
	\|\|Nonconformant event types		\|\|Nonconformant event types
	\|\|Each nonconformant event type in the filtered eventlog. The conformance analysis is run using the selected BPMN model (or BPMN model in the ''designModel'' variable).		\|\|Each nonconformant event type in the filtered eventlog. The conformance analysis is run using the selected BPMN model (or BPMN model in the ''designModel'' variable).
			\|-
			\|\|Role assignments
			\|\|Gives all role assignments in the system. One role assignment is created, when a certain role is assigned to a certain user to a certain project.
	\|-		\|-
	\|\|Task log		\|\|Task log

TeeHiet: TK-53330

2024-06-04T11:50:21Z

TK-53330

← Older revision		Revision as of 11:50, 4 June 2024
Line 99:		Line 99:
	* '''Only logins''': Show only tasks originated from user logins.		* '''Only logins''': Show only tasks originated from user logins.
	* '''Only tasks longer than''': Show only tasks where duration is longer than specified.		* '''Only tasks longer than''': Show only tasks where duration is longer than specified.
	* '''Dashboards''': Multiselect list of all dashboards in the server. When one or more dashboard is selected, only tasks related to the selected dashboards are shown (dashboard created, dashboard modified, dashboard opened).		* '''Dashboards''': Multiselect list of all dashboards on the server. When one or more dashboard is selected, only tasks related to the selected dashboards are shown (dashboard created, dashboard modified, dashboard opened).
	\|-		\|-
	\|\|Running tasks at specific time		\|\|Running tasks at specific time

TeeHiet: TK-53330

2024-06-04T11:48:59Z

TK-53330

← Older revision		Revision as of 11:48, 4 June 2024
Line 99:		Line 99:
	* '''Only logins''': Show only tasks originated from user logins.		* '''Only logins''': Show only tasks originated from user logins.
	* '''Only tasks longer than''': Show only tasks where duration is longer than specified.		* '''Only tasks longer than''': Show only tasks where duration is longer than specified.
			* '''Dashboards''': Multiselect list of all dashboards in the server. When one or more dashboard is selected, only tasks related to the selected dashboards are shown (dashboard created, dashboard modified, dashboard opened).
	\|-		\|-
	\|\|Running tasks at specific time		\|\|Running tasks at specific time

TeeHiet: TK-53330

2024-06-04T11:45:50Z

TK-53330

← Older revision		Revision as of 11:45, 4 June 2024
Line 94:		Line 94:
	* '''Only running tasks''': Show only tasks that are currently running.		* '''Only running tasks''': Show only tasks that are currently running.
	* '''Only cancelled tasks''': Show only tasks that have been cancelled.		* '''Only cancelled tasks''': Show only tasks that have been cancelled.
			* '''Only dashboard opens''': Show only tasks that fetch dashboard definition from the server.
	* '''Only model related tasks''': Show only tasks that are related to a model.		* '''Only model related tasks''': Show only tasks that are related to a model.
	* '''Only user related tasks''': Show only tasks that are related to a user.		* '''Only user related tasks''': Show only tasks that are related to a user.

Ollvihe: /* Measure aggregations */

2023-11-18T16:38:20Z

Measure aggregations

← Older revision		Revision as of 16:38, 18 November 2023
Line 8:		Line 8:
	* Booleans are aggregated by calculating the number of ''true'' values.		* Booleans are aggregated by calculating the number of ''true'' values.

	For the ''percentile'' aggregation, the percentile value between 0 % and 100 % needs to be selected. Actually, 0% is the same as the minimum value, 50% is the median, and 100% is the maximum value.		For the '''percentile''' aggregation, the percentile value between 0 % and 100 % needs to be selected. Actually, 0% is the same as the minimum value, 50% is the median, and 100% is the maximum value.

	For the ''list'' and ''unique list'' aggregations, the separator between the listed items can be changed (by default, it's comma and space). In addition for the ''list'' aggregation, order of the listed items can be defined in the measure settings (in the ''List ordering'' tab). The unique list is always sorted by the listed values (alphabetically or from smallest to largest).		For the '''list''' and '''unique list''' aggregations, the separator between the listed items can be changed (by default, it's comma and space). In addition for the ''list'' aggregation, order of the listed items can be defined in the measure settings (in the ''List ordering'' tab). The unique list is always sorted by the listed values (alphabetically or from smallest to largest).

	Note that the aggregation selection needs to be made also for custom measures because the custom expression doesn't contain the aggregation calculation, as the expression defines only how each row is calculated.		Note that the aggregation selection needs to be made also for custom measures because the custom expression doesn't contain the aggregation calculation, as the expression defines only how each row is calculated.

Ollvihe: /* Measure aggregations */

2023-11-18T16:36:55Z

Measure aggregations

← Older revision		Revision as of 16:36, 18 November 2023
Line 15:		Line 15:

	In addition to the above mentioned aggregations, the following special aggregations are available for all data types:		In addition to the above mentioned aggregations, the following special aggregations are available for all data types:
	* "Any" aggregation selects one of the aggregated items as the final aggregated value (it's undetermined which one of the ~~values~~ is selected). When it's known that all the aggregated items contain a same value, the ''Any'' aggregation is the fastest method to get the value. Also, when it's known that there is only a single value to be aggregated, the ''Any'' aggregation can be used to pick it.		* '''Any''' aggregation selects one of the aggregated items as the final aggregated value, and it's undetermined which one of the items is selected. When it's known that all the aggregated items contain a same value, the ''Any'' aggregation is the fastest method to get the value. Also, when it's known that there is only a single value to be aggregated, the ''Any'' aggregation can be used to pick it.
	* "None" aggregation ~~won't~~ do the aggregation at all and thus won't return any data for the measure. The ''None'' aggregation can be used when the non-aggregated measure value is referred by other measure or dimension using the variable reference, and thus the aggregated value is not needed.		* '''None''' aggregation will not do the aggregation at all and thus won't return any data for the measure. The ''None'' aggregation can be used when the non-aggregated measure value is referred by other measure or dimension using the variable reference, and thus the aggregated value is not needed.

	== Using chart variables ==		== Using chart variables ==

Ollvihe at 16:34, 18 November 2023

2023-11-18T16:34:38Z

← Older revision		Revision as of 16:34, 18 November 2023
Line 1:		Line 1:
	'''Big Data Chart''' is a chart visualization ~~performing calculations in~~ Snowflake, whereas the [[QPR_ProcessAnalyzer_Chart\|in-memory chart]] ~~uses~~ the ~~QPR ProcessAnalyzer~~ in-memory ~~calculation engine~~. [[QPR_ProcessAnalyzer_System_Architecture#Snowflake-Powered_Calculation\|Snowflake-powered calculation]] will enable practically unlimited scaling when the amount of data and number of users ~~grow~~.		'''Big Data Chart''' is a chart visualization used for Snowflake models (whereas the [[QPR_ProcessAnalyzer_Chart\|in-memory chart]] is used for the in-memory models). When a Snowflake model is selected, Big data charts can be added to dashboard in the tool palette by clicking the '''Chart''' icon. [[QPR_ProcessAnalyzer_System_Architecture#Snowflake-Powered_Calculation\|Snowflake-powered calculation]] will enable practically unlimited scaling when the amount of data and number of users increase.

	== Measure aggregations ==		== Measure aggregations ==

Ollvihe: /* Analyzed objects */

2023-09-04T23:18:51Z

Analyzed objects

← Older revision		Revision as of 23:18, 4 September 2023
Line 81:		Line 81:
	\|\|Root causes		\|\|Root causes
	\|\|This analyzed objects is used by the Root causes analysis and it gives one row for each root cause finding. See the Root causes presets to see examples.		\|\|This analyzed objects is used by the Root causes analysis and it gives one row for each root cause finding. See the Root causes presets to see examples.
			\|-
			\|\|Clustering cases
			\|\|Performs the clustering analysis followed by root causes analysis. See the Clustering analysis preset for how to use this selection.
			\|-
			\|\|Nonconformant event types
			\|\|Each nonconformant event type in the filtered eventlog. The conformance analysis is run using the selected BPMN model (or BPMN model in the ''designModel'' variable).
	\|-		\|-
	\|\|Task log		\|\|Task log

← Older revision		Revision as of 17:34, 13 June 2024
Line 87:		Line 87:
	\|\|Nonconformant event types		\|\|Nonconformant event types
	\|\|Each nonconformant event type in the filtered eventlog. The conformance analysis is run using the selected BPMN model (or BPMN model in the ''designModel'' variable).		\|\|Each nonconformant event type in the filtered eventlog. The conformance analysis is run using the selected BPMN model (or BPMN model in the ''designModel'' variable).
			\|-
			\|\|Role assignments
			\|\|Gives all role assignments in the system. One role assignment is created, when a certain role is assigned to a certain user to a certain project.
	\|-		\|-
	\|\|Task log		\|\|Task log

← Older revision		Revision as of 23:18, 4 September 2023
Line 81:		Line 81:
	\|\|Root causes		\|\|Root causes
	\|\|This analyzed objects is used by the Root causes analysis and it gives one row for each root cause finding. See the Root causes presets to see examples.		\|\|This analyzed objects is used by the Root causes analysis and it gives one row for each root cause finding. See the Root causes presets to see examples.
			\|-
			\|\|Clustering cases
			\|\|Performs the clustering analysis followed by root causes analysis. See the Clustering analysis preset for how to use this selection.
			\|-
			\|\|Nonconformant event types
			\|\|Each nonconformant event type in the filtered eventlog. The conformance analysis is run using the selected BPMN model (or BPMN model in the ''designModel'' variable).
	\|-		\|-
	\|\|Task log		\|\|Task log