In the functions tab, search for the Sum function and then select the function.
First click the Add button next to the custom fields.
<ul><li> Select <strong>Table Calculation</strong>.</li></ul><ul><li> Then type <strong>Sum</strong> and enter the necessary parameters.</li></ul><ul><li> Choose a name for the table calculation and click <strong>Save</strong>.</li></ul> <ul>
<li> Select <strong>Table Calculation</strong> . </li>
</ul>
<ul>
<li> Then type <strong>Sum</strong> and enter the necessary parameters. </li>
</ul>
<ul>
<li> Choose a name for the table calculation and click <strong>Save</strong> . </li>
</ul>
Search for the round function then select it from the tab.
First, click the Add button next to the custom fields.
<ul><li> Select <strong>Table Calculation</strong>.</li></ul><ul><li> Type <strong>Round</strong> and enter the necessary parameters.</li></ul><ul><li> Choose a name for the table calculation and click <strong>Save</strong>.</li></ul> <ul>
<li> Select <strong>Table Calculation</strong> . </li>
</ul>
<ul>
<li> Type <strong>Round</strong> and enter the necessary parameters. </li>
</ul>
<ul>
<li> Choose a name for the table calculation and click <strong>Save</strong> . </li>
</ul>
Search for the Now function and then select it from the Functions tab.
First, click the Add button next to the custom fields.
<ul><li> Select <strong>Table Calculation</strong>.</li></ul><ul><li> Then type <strong>Now</strong>.</li></ul><ul><li> Choose a name for the table calculation and click <strong>Save</strong>.</li></ul> <ul>
<li> Select <strong>Table Calculation</strong> . </li>
</ul>
<ul>
<li> Then type <strong>Now</strong> . </li>
</ul>
<ul>
<li> Choose a name for the table calculation and click <strong>Save</strong> . </li>
</ul>
Search for the Median function in the Functions tab. Then click the function to bring the median function into the formula editor.
First, click the Add button next to the custom fields.
<ul><li> Select <strong>Table Calculation</strong>.</li></ul><ul><li> Then type <strong>Median</strong> and enter the necessary parameters.</li></ul><ul><li> Choose a name for the table calculation and click <strong>Save</strong>.</li></ul> <ul>
<li> Select <strong>Table Calculation</strong> . </li>
</ul>
<ul>
<li> Then type <strong>Median</strong> and enter the necessary parameters. </li>
</ul>
<ul>
<li> Choose a name for the table calculation and click <strong>Save</strong> . </li>
</ul>
Search for the Max function and click it to add it to the formula editor.
First, click the Add button next to the custom fields.
<ul><li> Select <strong>Table Calculation</strong>.</li></ul><ul><li> Then type <strong>Max</strong> and enter the necessary parameters.</li></ul><ul><li> Choose a name for the table calculation and click <strong>Save</strong>.</li></ul> <ul>
<li> Select <strong>Table Calculation</strong> . </li>
</ul>
<ul>
<li> Then type <strong>Max</strong> and enter the necessary parameters. </li>
</ul>
<ul>
<li> Choose a name for the table calculation and click <strong>Save</strong> . </li>
</ul>
If - Executes a numeric expression based on a condition
In the Functions tab, search for if and then select the function.
First, click the Add button next to the custom fields.
<ul><li> Select <strong>Table Calculation</strong>.</li></ul><ul><li> Then type <strong>IF</strong> and enter the necessary parameters.</li></ul><ul><li> Choose a name for the table calculation and click <strong>Save</strong>.</li></ul> <ul>
<li> Select <strong>Table Calculation</strong> . </li>
</ul>
<ul>
<li> Then type <strong>IF</strong> and enter the necessary parameters. </li>
</ul>
<ul>
<li> Choose a name for the table calculation and click <strong>Save</strong> . </li>
</ul>
Floor- Returns the number rounded down to the nearest multiple of “1”
Search for the Floor function and then click it to bring into the formula.
First, click the Add button next to the custom fields.
<ul><li> Select <strong>Table Calculation</strong>.</li></ul><ul><li> Then type <strong>Floor</strong> and enter the necessary parameters.</li></ul><ul><li> Choose a name for the table calculation and click <strong>Save</strong>.</li></ul> <ul>
<li> Select <strong>Table Calculation</strong> . </li>
</ul>
<ul>
<li> Then type <strong>Floor</strong> and enter the necessary parameters. </li>
</ul>
<ul>
<li> Choose a name for the table calculation and click <strong>Save</strong> . </li>
</ul>
to filter a field inside a formula, add the field next to the original field, click it, select Rename , and then choose the filter.
To add a filter, click on the Filter button next to the field name.
<ul><li> Then you will see the filter at the top of the visualization.</li></ul> <ul>
<li> Then you will see the filter at the top of the visualization. </li>
</ul>
Day Difference- Returns difference between start and end time
Search for day difference in the Functions tab then select the day difference function.
First, click the Add button next to the custom fields.
<ul><li> Select <strong>Table Calculation</strong>.</li></ul><ul><li> Then type <strong>diff_days</strong> and enter the necessary parameters.</li></ul><ul><li> Choose a name for the table calculation and click <strong>Save</strong>.</li></ul> <ul>
<li> Select <strong>Table Calculation</strong> . </li>
</ul>
<ul>
<li> Then type <strong>diff_days</strong> and enter the necessary parameters. </li>
</ul>
<ul>
<li> Choose a name for the table calculation and click <strong>Save</strong> . </li>
</ul>
In the Functions tab type Count and select the function. Then navigate to the Data Browser tab, and click processname inside of the function.
First, click the Add button next to the custom fields.
<ul><li> Select <strong>Table Calculation</strong>.</li></ul><ul><li> Type <strong>Count_Distinct</strong> and enter the necessary parameters.</li></ul><ul><li> Choose a name for the table calculation and click <strong>Save</strong>.</li></ul><ul><li> Optionally, select the three dots next to a field and click <strong>Count</strong>.</li></ul> <ul>
<li> Select <strong>Table Calculation</strong> . </li>
</ul>
<ul>
<li> Type <strong>Count_Distinct</strong> and enter the necessary parameters. </li>
</ul>
<ul>
<li> Choose a name for the table calculation and click <strong>Save</strong> . </li>
</ul>
<ul>
<li> Optionally, select the three dots next to a field and click <strong>Count</strong> . </li>
</ul>
Count All - returns actual item count of list of items, including duplicates
Example: DUPCount(ProcessName)
In the Functions tab, search for Count All, and then select the statistical function.
First, click the Add button next to the custom fields.
<ul><li> Select <strong>Table Calculation</strong>.</li></ul><ul><li> Then click <strong>Type Count</strong> and enter the necessary parameters.</li></ul><ul><li> Choose a name for the table calculation and click <strong>Save</strong>.</li></ul><ul><li> Optionally, select the three dots next to a field and click <strong>Count</strong>.</li></ul> <ul>
<li> Select <strong>Table Calculation</strong> . </li>
</ul>
<ul>
<li> Then click <strong>Type Count</strong> and enter the necessary parameters. </li>
</ul>
<ul>
<li> Choose a name for the table calculation and click <strong>Save</strong> . </li>
</ul>
<ul>
<li> Optionally, select the three dots next to a field and click <strong>Count</strong> . </li>
</ul>
Case- Executes the result expression based on the condition. If no condition is met, the else condition is returned
Search for the Case function and then select it from the Functions tab.
First, click the Add button next to the custom fields.
<ul><li> Select <strong>Table Calculation</strong>.</li></ul><ul><li> Then type <strong>Case</strong> and enter the necessary parameters.</li></ul><ul><li> Choose a name for the table calculation and click <strong>Save</strong>.</li></ul> <ul>
<li> Select <strong>Table Calculation</strong> . </li>
</ul>
<ul>
<li> Then type <strong>Case</strong> and enter the necessary parameters. </li>
</ul>
<ul>
<li> Choose a name for the table calculation and click <strong>Save</strong> . </li>
</ul>
Search for Average in the Functions tab, then select it.
First, click the Add button next to the custom fields.
<ul><li> Select <strong>Table Calculation</strong>.</li></ul><ul><li> Type <strong>mean</strong> and enter the necessary parameters.</li></ul><ul><li> Choose a name for the table calculation and click <strong>Save</strong>.</li></ul> <ul>
<li> Select <strong>Table Calculation</strong> . </li>
</ul>
<ul>
<li> Type <strong>mean</strong> and enter the necessary parameters. </li>
</ul>
<ul>
<li> Choose a name for the table calculation and click <strong>Save</strong> . </li>
</ul>
In the Functions tab, search for Ceiling, and then choose that function to bring into the formula editor.
First, click the Add button next to the custom fields.
<ul><li> Select <strong>Table Calculation</strong>.</li></ul><ul><li> Then type <strong>Ceiling</strong> and enter the necessary parameters.</li></ul><ul><li> Choose a name for the table calculation and click <strong>Save</strong>.</li></ul> <ul>
<li> Select <strong>Table Calculation</strong> . </li>
</ul>
<ul>
<li> Then type <strong>Ceiling</strong> and enter the necessary parameters. </li>
</ul>
<ul>
<li> Choose a name for the table calculation and click <strong>Save</strong> . </li>
</ul>
