N O T I C E
MSPbots WIKI is moving to a new home at support.mspbots.ai to give you the best experience in browsing our Knowledge Base resources and addressing your concerns. Click here
for more info!
Page History
This article will help you shows how to add a calculate later in your layer to a widget. The calculate layer is used in grid-type widgets if you when users want to display a column that would compute for computes a value using the other columns in the widget.
...
To add a calculate layer in a widget:
- Go to Widget Widgets on the MSPbots menu.
- Click on the New Widget button.
...
- Click Grid on Grid the New Widget window.
- You will then be redirected to the Widget builderBuilder.
- Provide the necessary info for this Widget widget like the Name, Description, and Role. Click on Save after.
- Click on Data Source. Then Click on Data Source
- , then click Apply.
- Click the Dataset icon then click the + button for Data Source.
- Select New Layer on the Add New Layer popupA pop up window will display. Select New Layer. Note that you need to create the columns first that before you will to can compute for your Calculate the calculate layer.
- On the Dataset window that appears, create Create the data source by adding the datasets, including the filters needed for your widget.
...
- Repeat steps F 6 and G 7 until you have all the columns you need needed to compute for your the calculate layer.
...
- Click on “the + ” button and Calculate layer to add your calculate layer
- select Calculate Layer.
- On the Calculate Layer window, fill in the Name, then the Formula to compute the A pop up window will appear. Fill in the name then the formula to compute for your calculate layer. Simply select the Data data sources to be used for the formula.
...
- You may choose a format for the Number
...
- Format Type by clicking the paintbrush icon and selecting a format.
- Once done, click on Save then Apply. Your The calculate layer will now appear.
...
Overview
Content Tools