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?
How do I assign a calculation to a specific customer?
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 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 just becomes another metric. So, you add a calculation to a widget the same way you add any metric to a widget. To learn how to do that, see How to Create Widgets.
How do I assign a calculation to a specific customer?
Assigning a calculation to a specific customer is the same as assigning any metric to a specific customer.
What happens if I switch from Basic Calculator to Advanced?
When you switch from the Basic to the Advanced Calculator, the system seamlessly preserves your existing calculations within the advanced calculation builder, ensuring uninterrupted continuity.
What happens if I switch from Advanced Calculator to Basic?
Transitioning from the Advanced to the Basic Calculator will erase any previously constructed calculations. Consequently, you will need to rebuild your calculation from the beginning.
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, by default, will be turned on. 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?
What does the "disable duplicate row logging" toggle do?
What functions does the Calculation feature support?
See this article.
How do I review changes made to my calculations?
Super Admin users can see who, where, and what was changed in your calculations using the Audit Logs feature. For more information on Audit Logs, please 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. They allow you to tailor formulas and metrics to meet the unique needs of each client.
For more details, please refer to our 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.