HomeGuidesRecipesAPI
HomeGuidesAPILog In

Analytics Project Results

SmartIQ allows to create projects based on the results of submissions of other projects.

Manage
Create an "SmartIQ" Data Source in Manage.
Add a new Data Object "Analytics Project Results"as indicated in the diagram below:

1186

When "Analytics Project Results" is selected, the "Data Object Name/Definition" field can be used to define a Project Name in the SmartIQ instance. Entering any starting character, projects whose titles start with the same sequence, will be displayed in the pull down menu for selection.

Add an appropriate Display name and then hit the SAVE button.

The Available Filter Fields for the Data Source are the Answers in that particular Project.
Add all or selected answers from the "Available Filter Fields" list to the "Filter Fields" list - then click SAVE.

Available Filter FieldsDescription
_Completed_Completed = 1 if the form was completed, otherwise 0

Note: A response report will return Completed forms when "_Completed = 1"

Completed forms are forms that have been completed.
_CompletionTimeUTCThe UTC time when the form was completed
_CurrentStateThe current state of the form
_UsernameUser Name who Completed the project
_WorkflowInProgress_WorkflowInProgress = 1 if the form was completed, otherwise 0

Note: A response report will return WorkflowInProgress forms when "_WorkflowInProgress = 1"

WorkflowInProgress forms are forms that have been submitted atleast once throughout the workflow.

📘

Note

Default Filter Field values are set as below:
_Completed = 1 ; _WorkflowInProgress = 0

979

Repeaters

If the project has Repeaters, the repeated data elements will appear as shown below:

373

Configuring for data within Repeaters

For the above sample Project with a single Repeater within it, build the form as follows:

  1. Setup a Data Source question using the main Project Data Source as normal
1914
  1. Setup a second Data Source question (referred to as Child Project Results in the screenshot below). This question can be configured to point to the first Data Source question - thus allowing data in the one repeat section to be displayed. The same approach can be applied for Project with multiple nested Repeats.
1919

In the Table/View option, you will see the display name of the recently configured "Analytics Project Results" data object.

454