Calculation types reference

 In Explore you can perform calculations on your results using either result manipulations or custom metrics and attributes. 

This article contains the following sections:

• Result manipulations
• Calculated metrics and attributes

Result manipulations

You can use the Result manipulation menu () to create simple calculations without entering formula or creating new metrics. Result manipulations are added after your query is processed and can only use metrics and attributes already added to your query. 

You can use result manipulations to calculate the percentage difference, add totals, create a predictive analysis, and more. 

Below are the available results manipulations: 

• Sort results
• Totals
• Top/bottom filter
• Metric filter
• Result path calculation
• Result metric calculation
• Hide part of your result
• Forecasting
• Order of result manipulations

Calculated metrics and attributes

You can create custom, calculated metrics and attributes in the Calculations menu (). Calculated metrics and attributes are applied before your results are processed. Calculated metrics and attributes are more complex than result manipulations. 

Note: Some calculated metrics and attributes require you to enter formulas. You must use Explore's unique formula writing language (see Formula writing resources). You cannot enter MAQL, the language used by Insights.  

Below are the available calculated metrics and attributes:

• Standard calculated metric
• Date range and time comparisons
• Fixed calculated metric
• Standard calculated attribute
• Group
• Set
• Ordered set
• Renamed set
• Top/bottom attribute
• Global variable