1- Overview
User Defined Formulas generate the data points used in metrics and viewed in the Dashboard - ‘Key Performance Indicators’ (KPI), and in ‘KPI Cards’. These formulas allow you to break down KPI summaries by any metric, and can also generate the data points requested in API calls.
In general, formulas are used to define the math for how data points are combined into user defined records. This feature gives users the opportunity to define the conditions and events for a value they wish to monitor, compare, or visualize.
2- Configure Formulas
2.1- Analytics Setup
In the Analytics Platform, click the ‘Analytics Setup’ button in the main menu. Then click ‘Formula Editor’ in the menu.
On the User Defined Formula page, click the ‘Create New Formula’ button, as shown below.
In the pop-up window, select to enable the desired tools for viewing the Formula values: Dashboard KPI, KPI Cards. Enter a Formula Name. Add optional Description and Tags, and click the ‘Create’ button to save the formula.
Now that you’ve created the Formula, click the Name (link) or click the edit button (), next to the formula name you wish to edit. In the next four sections (2.2 - 2.5) we’ll review the four steps to configure your new formula.
2.2- Data Point to Summarize
In the first section you will define a ‘Formula Type’, by selecting Event Count, Event Average or Event Sum. Then select the desired (Area of Interest) AOI, Datasource and Datapoint, as shown below
Data Point to Summarize 
2.3- Conditions
In the second section you will select one of the standard demographic Datapoints, such as age, proximity or gender, then select an operator, and then a value. For example: AGE > 50
Conditions 
2.3.1- Datapoints
- Age - Numeric value as identified by sensor
- Proximity - Distance from the sensor
- Dwell Time - Numeric value of time in milliseconds
- Gender - Male/Female as identified by sensor
- Has Mask - Person is wearing a mask (Covid)
- Emotion - Emotion as identified by sensor (e.g. Neutral, Happy, Surprised)
- Person Type - As defined in People Management (e.g. Employee, Guest)
- Repeat Visitor - Identified using facial pattern recognition by the sensor
2.4- Apply Math
In the third section you may create a math equation, by selecting an ‘Operation’ and ‘Value’.
Apply Math
2.5- Data Breakdown
And in the fourth section you can create a data breakdown, by selecting one of the Datasources, defined in step 1 - ‘Datapoint to Summarize’. Then select a ‘Datapoint to Breakdown’, form the menu, as shown below.
Data Breakdown
3- Viewing Formula Output
3.1- Key Performance Indicators (KPI)
From the Dashboard, you can view bar charts and line graph comparisons of any two selected KPIs. In addition to four bar charts, comparing the KPI’s Average by Day and by Hour, a line graph displays a comparison of any two KPIs.
Line Graph comparison of KPI-1 vs KPI-2
Bar Chart comparison by Day and Hour of KPI-1 vs KPI-2
3.2- KPI Cards
InReality’s user defined analytics allows you to view and configure ‘KPI Cards’. At the main menu, click ‘KPI Cards’. The ‘KPI Cards’ are easily configured to provide timely key metrics data to users on a recurring basis. They are designed to allow you to monitor KPIs on a daily basis. The cards may be viewed on your mobile and leverage AI to identify important correlations and relationships. The cards may also expose anomalies, which you can quickly respond to as they occur.
You can create a Card Deck and individual KPI Cards. Cards may be shared with any number of associates. To create a new Card or Deck, click on the ‘Create New Deck’, or ‘Create New Card’ button. Click the ‘Share View’ button to share the defined data with others.
3.3- API
InReality’s measurement subscription packages allow users to view the data via formulas setup in InReality’s Analytics Portal via Dashboard - KPIs, and KPI Cards. In addition the data is also available via InReality’s API (Application Programming Interface).
InReality offers an extensive data extraction API for our customers and partners to access your metrics data from InReality's platform. Raw data, along with data from User Defined Formulas can easily be integrated into your Business Intelligence (BI) platform or Visualization tools.