The MSPbots app has a Calculate Measure Function that provides the six measure functions sum, count, avg, max, min., and string_agg. This feature is found under Advance Measure settings in the Widget Builder.
Where can I find the Calculate Measure Function?
- Go to Widgets on the MSPbots app and select the widget to be configured.
- On the Widget Builder window, click the Dataset icon, click the + button, and select New Layer.
- Next, scroll down to the Measure section on the Dataset window and click the + button.
- When the Measure box opens, click Advance.
The Calculate Measure settings box opens.
When can I use this function?
One of the ways to use the Calculate Measure function is to display the username values in uppercase. Below is how the user names are shown before utilizing the function:
To display these values in uppercase:
-
Input the following on the Dataset window:
- Calculate measure: upper(user_name)
- Alias: username
Note: The username is the column name.
-
Click Confirm. Below are the values after the configuration.