Understand Scheduled KPI Datapoints
Scheduled KPI datapoints are computed values based on expressions, with datapoint values from the same model, related models, and field configured for the model, aggregated using a function over a period. These expressions are executed at defined intervals.
A computational expression consists of field values, constant values, datapoints, and mathematical operators. Learn more about how each filed is used and how an expression can be configured in expression builder for datapoints.
For scheduled KPI datapoints, the available Aggregation Functions and period of aggregation are tabulated below.
Aggregate Function | Output Value |
MAX | Maximum value of the datapoint value aggregated over the specifie period. |
MIN | Minimum value within the datapoint value aggregated over the set period. |
SUM | Summation of all the datapoint values aggregated over the set period. |
AVG | Average of all the datapoint values aggregated over the set period. |
FIRST_VALUE | First datapoint value received within the set period. |
LAST_VALUE | Last datapoint value received within the set period. |
Aggregation Timeline | |
Last 1 Hour | Last 6 Hours |
Last 12 hours | Today |
Yesterday | Last 7 Days |
Last 30 Days | Last Week |
Last Month | Last 24 Hours |
This Week | This Month |
Consider a scenario where you need to calculate the daily cost of energy consumption. The energy meter sends the current consumption data every 10 minutes in a JSON format, which is stored in a realtime datapoint called "Energy Consumed."
Additionally, the energy rate, which changes monthly, is stored in a custom field called "Energy Rate" in the managed entity instance. This field allows the user to input the current energy rate manually.
To compute and store the daily cost of energy, a Scheduled KPI datapoint is created. This datapoint uses expression with a SUM function to aggregate all the values from 'Energy Consumed,' and with the period defined as 'Today,' only the values for the current day are used.
The total consumption is then multiplied by the value in the 'Energy Rate' field, thus calculating the total cost of energy for that day. The Scheduled KPI datapoint now stores the daily energy cost.
See Also
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
New to Zoho Writer?
Create. Review. Publish.
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
New to Zoho Survey?
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho ZeptoMail?
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
New to Bigin?
Related Articles
Understanding Datapoints
Datapoint is a unique time series data represented as a time stamped key- value pair, and is available for assets, devices, and locations in the Zoho IoT application. It is the source of data for other features in the application and is vital in ...Understanding Expression Builder for Datapoints
Expression builders are used to create expression for computing values based on a set of available datapoints, fields, or constants and storing them as realtime or scheduled KPI datapoints. Note: Expression builder is available by default for ...Configuring Fields: Datapoints
This guide outlines the steps to configure various fields when creating a datapoint. Each section details the options available and provides examples for clarity. Field Description Example Datapoint Type Options: Choose between Realtime Datapoint or ...Understanding Device Models
A device model serves as a blueprint and can be configured with the following : Datapoint templates Command templates Overview dashboards templates Custom fields Alarm rule templates Message Handler and Formatters Model Settings Every device created ...Adding and managing datapoints and datapoint templates
This guide explains how to add, edit, delete, and manage datapoints and datapoint templates in a Zoho IOT application Adding datapoints and datapoint templates Datapoint templates are added/imported to a model, and the device, asset, or location ...
New to Zoho LandingPage?
Zoho LandingPage Resources