- Release Notes
- Getting Started
- Access and Permissions
- Interacting with Insights
- Troubleshooting
Common Formulas
-
A user needs designer permissions and will need to navigate to the Insights Portal.
-
Then navigate to an existing dashboard or create a new dashboard.
-
Then edit a widget or create a new widget.
-
Then, the designer will have to click on the plus next to the values
-
Click the fx button to create a new formula
-
Here, you will see the functions tab
- Commonly used functions are highlighted for comparison in the table below.
-
A user needs designer permissions and can navigate to an existing dashboard or create one from scratch.
-
Then, the user must edit the dashboard.
-
Then select add tile and then choose visualization.
-
Then select an explore.
-
Create a new custom formula using the Add New Measure, Add New Dimension, or Table Calculation option.
Common Formulas |
Insights <2021.10 |
Insights 2021.10 |
---|---|---|
Sum- Adds the numbers in a list |
|
Note: See
more details here
|
Round- Returns the rounded number |
|
Note: See
more details here
|
Now - Returns the current time period |
|
Note: See
more details here
|
Median - calculates the median |
|
Note: See
more details here
|
Max |
|
Note: See
more details here
|
If - Executes a numeric expression based on a condition |
|
Note: See
more details here
|
Floor- Returns the number rounded down to the nearest multiple of “1” |
|
Note: See
more details here
|
Filter field in formula |
(Field, filtered field)
|
|
Day Difference- Returns difference between start and end time |
|
Note: See
more details here
|
Count- counts number of unique values |
|
Note: See
more details here
|
Count All - returns actual item count of list of items, including duplicates |
|
Note: See
more details here
|
Case- Executes the result expression based on the condition. If no condition is met, the else condition is returned |
|
Note: See
more details here
|
Average- Calculates the mean |
|
Note: See
more details here
|
ALL |
|
|
Ceiling- Rounds up to 1’s digit |
|
Note: See
more details here
|