Adding a Calculate Layer to a Widget

This article shows how to add a calculate layer to a widget. The calculate layer is used in grid-type widgets when users want to display a column that computes a value using the other columns in the widget. 

To add a calculate layer in a widget:  

1. Go to Widgets on the MSPbots menu.
2. Click on the New Widget button.
   
    
3. Click Grid on the New Widget window. You will be redirected to the Widget Builder. 
   
   
4. Provide the necessary info for this widget like the Name, Description, and Role, then click Apply.
   
   
5. Click the Dataset icon then click the + button for Data Source.
   
   
6. Select New Layer on the Add New Layer popup. Note that you need to create the columns before you can compute for the calculate layer. 
   
   
7. On the Dataset window that appears, create the data source by adding the datasets, including the filters needed for your widget.
   
   
8. Repeat steps 6 and 7 until you have all the columns needed to compute the calculate layer.
   
    
9. Click on the + button and select Calculate Layer.
   
   
10. On the Calculate Layer window, fill in the Name, then the Formula to compute the calculate layer. Simply select the data sources to be used for the formula. 
    
11. You may choose a format for the Number Format Type by clicking the paintbrush icon and selecting a format.
    
    
12. Once done, click Save then Apply. The calculate layer will now appear.