User Guide
×
Menu
Index
 

KPI-based Query

 
In the section Objects & KPIs you can perform analyses on predefined KPIs and Objects. The "Objects" field contains all available objects so you can calculate KPIs. Details in: Using Objects.
KPIs are predefined systems of questions and operations performed on them. All necessary filters and actions needed in the calculating process are already included in KPIs definitions. If a KPI is paired with an object, the object is automatically adjusted to the chosen KPI.  As a result, Halo Reports allows you to calculate KPI correctly simply by dragging the KPI to the Columns pane. The field where a KPI should be dragged is indicated by the text "Drop KPI here":
 
In addition to that, there are two types of KPIs implemented in Halo Reports. They can be recognized by different icons.
 
 
 
KPI-based Query
1

Data connection

1. Data connection
Connect to data in a similar way as for Questions.
2

Objects

2. Objects
Objects for which the KPIs can be calculated. You can drag it to the panes.
3

Single variable KPI

3. Single variable KPI
Using such a KPI, you will get results for an individual question in the spreadsheet.
4

Multivariable KPI

4. Multivariable KPI
Using multivariable KPIs leads to the results being calculated for each category of KPI. If you do not want to see results for some of them, you can apply a subset to such a KPI. Read more in Using Subsets.
5

Context menu for KPIs

5. Context menu for KPIs
Using the context menu, you can hide the KPI or move it to the Columns section (this can also be done by dragging and dropping it). Since the primary destination for KPIs is the pane "Columns," only this option is available from the KPI context menu.