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!
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!
This article will help you to add a calculate layer to your widget. The calculate layer is used in grid-type widgets if you want to display a column that would compute a value using the other columns in the widget.
To add a calculate layer in a widget:
- Go to Widgets on the MSPbots menu.
- Click on the New Widget button.
- Click Grid on the New Widget window. You will be redirected to the Widget Builder.
- Provide the necessary info for this widget like the Name, Description, and Role, then click Apply.
- Click the Dataset icon then click the + button for Data Source.
- Select New Layer on the Add New Layer popup that will display. Note that you need to create the columns before you can compute for the Calculate layer.
- On the Dataset window that appears, create the data source by adding the datasets including the filters needed for your widget.
- Repeat steps 6 and 7 until you have all the columns you need to compute for your calculate layer.
- Click on the + button and select Calculate Layer to add the calculate layer.
- On the Calculate Layer window that appears, fill in the Name, then the Formula to compute for your calculate layer. Simply select the 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 Save then Apply. The calculate layer will now appear.
Overview
Content Tools