GetAnalysis Script Examples - Revision history

Ollvihe at 14:21, 24 January 2024

2024-01-24T14:21:08Z

@@ Line 106: / Line 106: @@
 (SELECT 'SelectedAnalysisResult', 'ShowScript34Result') UNION ALL
 (SELECT 'ScriptId', '34')
 --#GetAnalysis
 </pre>

2023-06-15T18:34:28Z

@@ Line 97: / Line 97: @@
 (SELECT 'DataTableName', 'ExampleTable') UNION ALL
 (SELECT 'TargetTable', '#CSV1')
 --#GetAnalysis
 </pre>
@@ Line 134: / Line 126: @@
 (SELECT 'TargetTable', '#ScriptReport')
 --#GetAnalysis
 </pre>

2023-01-12T11:49:15Z

@@ Line 90: / Line 90: @@
 </pre>
 The following example will load data from the "ExampleTable" data table in the "ExampleProject" project and put that data into the "CSV1" table.
 <pre>
@@ Line 141: / Line 105: @@
 (SELECT 'Show', '1') UNION ALL
 (SELECT 'TargetTable', '#DataTableResult')
 --#GetAnalysis
 </pre>

2022-08-05T11:04:57Z

@@ Line 136: / Line 136: @@
 </pre>
 The following example will get a Data Table Report analysis, store the analysis results to a temporary table called "#DataTableResult" and show the results on an Excel sheet. This table contains the same information as is visible in the Project Workspace. For explanations of the columns, see Data Tables.
 <pre>
@@ Line 156: / Line 141: @@
 (SELECT 'Show', '1') UNION ALL
 (SELECT 'TargetTable', '#DataTableResult')
 --#GetAnalysis
 </pre>

2022-07-28T15:13:49Z

2022-07-28T15:12:39Z

2021-10-25T20:48:40Z

← Older revision		Revision as of 20:48, 25 October 2021
Line 1:		Line 1:
	This page contains script examples for the [[~~QPR ProcessAnalyzer~~ Scripting Commands#--.23GetAnalysis\|GetAnalysis]] script command.		This page contains script examples for the [[SQL Scripting Commands#--.23GetAnalysis\|GetAnalysis]] script command.

	This example runs an [[Web_API:_Expression/query\|expression analysis]].		This example runs an [[Web_API:_Expression/query\|expression analysis]].

2021-09-19T20:56:21Z

← Older revision		Revision as of 20:56, 19 September 2021
Line 11:		Line 11:
	"Dimensions": [		"Dimensions": [
	{		{
	"~~name~~": "Date",		"Name": "Date",
	"~~expression~~": "Duration.TotalDays"		"Expression": "Duration.TotalDays"
	"~~numberprecision~~": 0		"NumberPrecision": 0
	}		}
	],		],
	"Values": [		"Values": [
	{		{
	"~~name~~": "Count",		"Name": "Count",
	"~~expression~~": "Count(_)"		"Expression": "Count(_)"
	}		}
	],		],
	"Ordering": [		"Ordering": [
	{		{
	"~~name~~": "Date",		"Name": "Date",
	"Direction": "Ascending"		"Direction": "Ascending"
	}		}

2021-09-19T20:56:00Z

← Older revision		Revision as of 20:56, 19 September 2021
Line 12:		Line 12:
	{		{
	"name": "Date",		"name": "Date",
	"expression": "Duration.TotalDays~~.ToInteger(_)~~"		"expression": "Duration.TotalDays"
			"numberprecision": 0
	}		}
	],		],

2021-09-19T20:54:59Z

← Older revision		Revision as of 20:54, 19 September 2021
Line 56:		Line 56:
	{		{
	"Name": "dimension3",		"Name": "dimension3",
	"Expression": "Duration?.TotalDays"		"Expression": "Duration.TotalDays"
	},		},
	{		{