Page History

This article shows the following steps on how to create a card number widget:

• How to Create a Card Number Widget
• Example: How to Create a Card Number that shows the total tickets updated in the last 7 days.

...

How to Create a Gantt Chart Widget

1. Navigate to Widgets on the MSPbots app menu.
   
2. Under My Widgets, click New Widget.
   
   
3. Select the Gantt widget type on the New Widget window.
   
4. When the Widget Builder window opens, go to the Basic Setting tab. Provide the following and click Apply:
   • Name - Give the widget a name.
   • Description - Give the widget a short description.
   • Role - Select the roles you want to give access to.
     
5. Next, go to the Dataset tab. Click the  button and select New Layer. 
   
   
   
   
   
6. On the Dataset window,
   
   1. Select the Dataset containing the information you want to use.
   2. Give the data source a name and enter it in the Show datasource name as field (optional).
      Image RemovedImage Added
   3. For Columns Display
      1. On the Column Name drop-down, select the field fields you want to show include in the drill throughGantt Chart. Click the the  button to add more rows.  
      2. Give each row an Alias and select a Business Type for each.
         Image RemovedImage Added
   4. For Filter
      
      1. Click the  button and choose Add Condition or Add Group.
      2. Add all the fields you want to filter.
      3. Set a condition or logic for each field using the next two drop-downs. For a guide on each option, refer to: What Conditions are Available for Creating Widgets?
      4. Select a logical operator for the filter group (AND or OR).
         Image Removed
   5. 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 Removed
   6. 1. Image Added
   7. Click Save. 
      
      
7. Next, go to the Config tab.
   
   1. Under Column, you can choose which of the columns below to display in the gantt chart and the data source For Dimensions,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.
   5. Other optional settings are:
      
      1. Order By - Sorts the data based on the selected field. 
      2. Row Limit - Sets a limit on how many rows of data will be shown.
   Click Save. 
   
8. Next, go to the Config tab.
   
   1. Select the Measure to be shown in the card number.
   2. Set the Value Font Weight and Color.
   3. Add a Footer Title and set its Font Color (optional). 
      Image Removed
9. 1. each one.
      1. Group - will group the task name based on the field selected
      2. Task Name
      3. Resources
      4. Start Date
      5. End Date
      6. Duration - Adds "days" as a unit by default. If field selected is in hours, please divide the field by 24hrs using the Image Added button in the dataset window (step 6.c)
      7. Progress
         Image Added
   2. Under Timeline, you can configure how the dates will be shown. By default, it will show the dates weekly for Top tier and daily for Bottom tier.
      1. Count - per how many units will it show data for (ex: if unit is day and count is 2, it will show M-W-F-Su and so on)
      2. Unit - Hour, Day, Week, Month, Year
      3. Format - choose among the available date formats
         Image Added
10. Additionally, go to the Condition tab to set Conditional Formatting.
11. Add a rule and assign a name.
    Image Removed
    
Set the conditions for the rule.
Image RemovedSelect the text color to be applied once conditions are satisfied.
Click Apply. This will show a preview of the created card number Gantt Chart widget.
Image RemovedImage Added