Widget - How to add the Calculate layer

This article will help you to add a calculate later in your widget. The calculate layer is used in grid type widgets if you want to display a column that would compute for a value using the other columns in the widget.

1. Create New widget
   1. Go to Widget menu
   2. Click on New Widget

1. Click on Grid Widget.

1. You will then be redirected to the Widget builder. Provide the necessary info for this Widget like the Name, Description, Role. Click on Save after.

1. Click on Data Source. Then Click on Data Source

1. A pop up window will display. Select New Layer. Note that you need to create the columns first that you will to compute for your Calculate layer.

1. Create the data source by adding the datasets including the filters needed for your widget

1. Repeat steps F and G until you have all the columns you need to compute for your calculate layer

1. Click on “+” and Calculate layer to add your calculate layer

1. A pop up window will appear. Fill in the name then the formula to compute for your calculate layer. Simply select the Data sources to be used for the formula.

1. You may choose a format for the Number

1. Once done, click on Save then Apply. Your calculate layer will now appear.