Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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:  

  1. Go to Widget Widgets on the MSPbots menu.
  2. Click on the New Widget button.

...


  1. new widgetImage Added 
  2. Click Grid on Grid the New Widget window.

Image Removed

  1. You will then be redirected to the Widget builderBuilder. 
    grid type widgetImage Added
  2. Provide the necessary info for this Widget widget like the Name, Description, and Role. Click on Save after.

Image Removed

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

Image Removed

  1. , then click Apply.
    widget builderImage Added
  2. Click the Dataset icon then click the + button for Data Source.
    widget builder datasetImage Added
  3. 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. 

Image Removed

  1. new layer widgetImage Added
  2. On the Dataset window that appears, create Create the data source by adding the datasets, including the filters needed for your widget.

Image Removed

...

  1. datasetImage Added
  2. Repeat steps F 6 and G 7 until you have all the columns you need needed to compute for your the calculate layer.

...


  1. widget calculate layerImage Added 
  2. Click on the + button and Calculate layer to add your calculate layer

Image Removed

  1. select Calculate Layer.

    add calculate layerImage Added calculate layerImage Added
  2. 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. 

...

  1. calculate layer formulaImage Added
  2. You may choose a format for the Number

...

  1. Format Type by clicking the paintbrush icon and selecting a format.
    format formula numberImage Added
  2. Once done, click on Save then Apply. Your The calculate layer will now appear.

...

  1.  
    billable percentImage Added