Two types of Calculations can be created in CoolPlanetOS.
Calculation column, which utilises other Calculations or DataSource columns.
Single Value calculations, which utilises folded values of the different sources of data within its formula.
When creating a chart in Explore, you can populate it with data from a column (Reference, Calculation, Query or DataSource) or a Single Value.
What is a Single Value calculation?
Single Value calculations allow DataGrid columns to be folded into single-value outputs, which can be used in other calculations or charts.
When Should I Use SV Calculations?
This allows column fold-based KPI calculations to be accurately and consistently reported across a range of time granularities. These single-value calculations are performed once for the entire time range rather than being calculated at every row level. The full range of folds includes SUM, AVERAGE, MEDIAN, MINIMUM, MAXIMUM, FIRST VALUE, LAST VALUE and COUNT.
Where can I find calculated Single Values?
Single Values can be found or created within DataGrids on the sub-tab to the right. You can switch between Columns view or the Single Values view.
Creating a Single Value
On clicking the Single Values tab, the view lists any Single Values already created or you can create a new one by clicking on the New Single Value button.
Clicking 'New Single Value,' opens the Calculation Editor, where the value can be created. Learn more about the Calculation Editor here.
Examples of KPIs using Single Value calculations:
Electric vehicle efficiency: Electric vehicle efficiency for a given period can be calculated by summing the distance covered by the vehicle during the period and dividing it by the sum of the electricity used to cover the distance. In the calculation, the editor may look something like "SUM (Distance) / SUM (Electricity Consumed)."
Average energy consumed by a process: The average energy consumed by a process can be calculated by summing the energy used during the period and dividing it by the count of the times the process was run.
Electric Vehicle Fleet average electricity consumption: The average electricity consumption for a fleet of vehicles can be calculated by summing the electricity consumption of the vehicles and dividing by the number of vehicles in the fleet.