Page History

MSPbots Widgets help you to quickly view important data and highlight action items at a glance. This article shows how you can start creating your own widget which you can further customize according to This article has the steps for creating a grid-type widget that fits your business needs.

...

How to create a

...

Grid Widget:

1. Navigate to Widgets on the MSPbots app menu.
   Image Added
2. Under My Widgets
3. On the MSPbots menu, navigate to Widgets.
4. On the Widgets tab, click New Widget.
   Image RemovedImage Added
5. Choose the Grid widget type on the New Widget window.
   Image Modified
6. When the Widget Builder window opens, go to  the Basic Setting tab. Provide the following and click Apply.:
   • Name - Give the widget a Namename.
   • Description - Provide Give the widget a short Descriptiondescription.
   • Role - Select User or Adminthe roles that should have access to the widget.
     Image RemovedImage Added
     
7. Go to the Dataset tab. Click the +  button and add a select New Layer.Do the following o
   Image Added
   Image Added
8. On n the Dataset window: ,
   
   1. Select the Dataset containing the information you want to use.
   2. Enter a datasource name in the Show datasource name as field. (Optional)
      Image Added
   3. For Columns Display,
      1. Using the Column Name dropdown, select the field you want to show in the drill through. Click the  button to add more rows.  
      2. Give an Alias and select a Business Type for each row.
         Image Added
   4. For Filter,
      
   5. Select a dataset to use.
   6. Add columns by selecting an option from the Column Name dropdown list and assigning an Alias and Business Type for each. Click the button to add more rows.  
   7. Add filters, measures, and dimensions. Refer to
      1. Click the  button and choose between Add Condition and Add Group.
      2. Add all the fields you want to filter.
      3. Set a condition/logic for each field using the next two dropdowns. For a guide on each option, refer to:
      1. What Conditions are Available for Creating Widgets?
      as
      2. Select a
      guide for this step.
      Image Removed
9. Click Save. This will show a preview of the simple grid table that you created.
10. Click Apply.

You can modify this basic widget further to show details like how many tickets are created per technician or to show the statuses of each ticket.

...

1. 1. 1. logical operator for the filter group (AND or OR).
         Image Added
   2. For Measure,
      1. Click the button to show the Measure window.
      2. Select a Summary Type.
      3. Select a Field to use in the computation.
      4. Give an Alias for the measure.
      5. Select a Format Type.
      6. Click Add.
         Image Added
   3. For Dimensions,
      1. Select a field to be used for grouping the data.
      2. Give an Alias for the measure.
      3. Select a Format Type.
      4. Click Add.
         Image Added
         
   4. Other optional settings are:
      
      1. Order By - Sorts the data in the drill-down based on the selected field. 
      2. Row Limit - Sets a limit on how many rows of data will be shown in the drill-down.
         Image Added
         These two options are also available on the dataset tab, the difference is that they apply to the grid widget shown instead of the drill-down.
   5. Click Save.
      
      
2. Go to the Config tab.
   
   1. Under Grid Options, 
      1. Grid Lines - Select the type of grid lines to use for the table.
      2. Toolbar - Select the file types for the export feature.
      3. Show Paging - If toggled on, this will show the paging settings at the bottom of the table.
      4. Show Toolbar - If toggled on, this will show the toolbar at the top of the table.
      5. Font Size - Set the font size for the text in the table.
         Image Added
         
   2. Under Column Settings, you can edit the following for each column:
      1. Header Text - Assign a column name
      2. Header Tooltip - Add a tooltip for the column
      3. Text Align - Left, Center, Right
      4. Allow Filtering - Toggle to allow users to filter the column
      5. Disable HTML - Toggle to disable the use of HTML codes
      6. Max Width - Set the width for the column
      7. Aggregates - Select if the column's total will be included at the bottom of the table (sum, count, avg, min, max)
      8. Number Format - Set how many decimal places will be shown for the aggregate (only available if Average was selected)
         Image Added
         
3. Additionally, Conditional Formatting can be configured under the Condition tab.
   1. Add a rule and assign a name.
   2. Set the conditions for the rule.
   3. Select the format to be applied once conditions are satisfied. Choose to apply a cell or row color.
      Image Added
      Image Added
      
4. Click Apply. This will show a preview of the grid widget you created.
   Image Added