This document contains frequently asked questions that arise when working with Calculations in TapClicks. You can quickly navigate to a particular FAQ by using the table of contents below.
How do I add a calculation to a widget?
What happens if I switch from Basic Calculator to Advanced?
What happens if I switch from Advanced Calculator to Basic?
What occurs if I toggle between using and not using the Data Warehouse toggle?
How do I create a basic calculation?
How do I create a conditional statement in a calculation?
What is the post-aggregation functionality?
What does the "disable duplicate row logging" toggle do?
What functions does the Calculation feature support?
How do I review changes made to my calculations?
Can I create a calculation for a specific client?
Does the Data Exporter export calculated metrics?
How Do I Add a Calculation to a Widget?
Once you create a calculation, it becomes another metric. You add a calculation to a widget the same way you add any metric to a widget. See How to Create Widgets for more.
What Happens If I Switch from the Basic Calculator to Advanced?
When you switch from the Basic to the Advanced Calculator, the system preserves your existing calculations within the Advanced Calculation Builder, ensuring uninterrupted continuity.
What Happens If I Switch from Advanced Calculator to Basic?
Advanced calculations may include operations and functions not supported in the Basic Calculator. As a result, switching will clear any existing setup, and you will need to rebuild your calculation from scratch. If you did not intend to switch, you can cancel this action.
What Occurs If I Toggle Between Using and Not Using the Data Warehouse Toggle?
Activating or deactivating the Data Warehouse toggle will clear your currently selected data. You will need to reselect the Data Type, Data Category, and Data View, and reconstruct the formula.
How Do I Create a Basic Calculation?
When creating a new calculation, there is a toggle button titled Advanced Calculation, which will be turned on by default. Turn this toggle off to use the Basic Calculation Builder.
How Do I Create a Conditional Statement in a Calculation?
1] On the New Calculation page, ensure that you have the toggle for Advanced Calculation turned on.
2] In the Advanced Calculation Builder, in the Functions column, scroll down to the IF function and click it.
3] The logical expression appears in the Advanced Calculation Builder area.
4] You will need to replace the ovals with specific content. There are three ways to do that:
- Single click inside an oval and then click on an item in the Functions, Metrics, or Operators column. The oval is replaced with what you just clicked.
- Double-click inside an oval, type what you want, and hit Enter.
- Use the left/right arrows to navigate through the expression, hit Backspace to delete an oval, and type what you want to replace it.
| Note: You do not need parentheses to create your conditional statement. |
5] When you have the conditional statement the way you want, click Save.
What Is the Post-Aggregation Functionality?
See the Examples of Post-Aggregation Calculations article.
What Does the "Disable Duplicate Row Logging" Toggle Do?
The "disable duplicate row logging" toggle stops the platform from flagging duplicate row issues for a specific Smart Connector. When you turn it on, duplicate rows won't appear as warnings in the Data Load Status Dashboard or trigger email notifications. This is helpful if duplicate rows are expected in your data and you don't need to be alerted about them, letting you focus on other potential data issues instead.
What Functions Does the Calculation Feature Support?
See the Calculation Function Reference article.
How Do I Review Changes Made to My Calculations?
Super Admin users can see who made changes, where they were made, and what was changed in your calculations using the Audit Logs feature. For more information, refer to Understanding Audit Logs.
Can I Create a Calculation for a Specific Client?
Yes, you can create a calculation specifically for an individual client in TapClicks. These are known as Client Specific Calculations and allow you to tailor formulas and metrics to meet the unique needs of each client.
For more details, refer to FAQs: Client Specific Calculations and How to Create Client Specific Calculations.
Does the Data Exporter Export Calculated Metrics?
Yes, the Data Exporter in TapClicks can export Calculated Metrics. These metrics are treated like standard metrics. Calculated Metrics will appear alongside standard metrics in the data fields selection list when configuring a Data Export.