How to Create a Gantt Chart Widget

This article is a guide for creating a Gantt Chart widget. Follow this procedure to create a table of tasks or projects with the start time, duration, end time, progress, and assigned resources.

Log in to MSPbots as an admin.
Navigate to Widgets on the MSPbots app menu and click New Widget.
Select the Gantt widget type in the New Widget window.
Fill in the following fields for Basic Setting.
- Name - Give the widget a name.
- Description - Give the widget a short description.
- More Info
- Role - Select the roles that will have access to the widget. The roles selected by default are Admin, User, and Dashboard Only.
- Tag
Click Apply when done.
Click to go to Dataset and click the + button.
Click New Layer.
In the Dataset window,
1. Select the Dataset with the data you need.
2. (Optional) Enter a datasource name in the Show datasource name as field.
3. For Columns Display,
  1. Go to the Column Name dropdown and select a field for the drill-through.
  2. Give an Alias and select a Business Type for your selection.
  3. Click the + button to add more rows.
4. For Filter,
  1. Click the add button and select Add Condition or Add Group.
  2. Select the fields you want to filter.
  3. Set conditions for each field using the subsequent two dropdowns.
    For a guide on each option on the list, refer to What Filter Conditions and Formats are Available for Creating Widgets.
  4. Select the logical operator AND or OR for the filter group.
5. For Measure,
  1. Click the + button corresponding to Measure.
  2. When the Measure window opens, select a Summary Type.
  3. Select a computation option from the Fields list.
  4. Type an Alias for the measure.
  5. Select a Format Type.
  6. Click Add.
6. For Dimension,
  1. Click the + button sign corresponding to Dimension.
  2. Select a grouping option from the Fields dropdown.
  3. Give an Alias for the dimension.
  4. Select a Format Type.
  5. Click Add.
7. For DrillThrough Order By,
  1. Click the + icon.
  2. Select a parameter to sort drill-throughs automatically.
8. (Optional) For Order By,
  1. Click the + icon.
  2. Select a parameter to sort the data.
9. Row Limit - Select an option to set a limit on how many rows of data will be shown. (Optional)
10. Remove duplicate data - Select this option if you have duplicate data to delete.
11. Materialized - Select an option according to your requirements.
12. Click Save to keep the Dataset configuration.
  
  The optional settings Order By and Row Limit are also available in the Widget Builder window. The settings configured in this area are applied to the grid widget. If the configurations were done in the Dataset window, the settings are applied to the drill-down.
Click Apply.
Next, click the Config icon.
1. On the Column tab, choose the columns to display in the Gantt chart and select the data source field for each.
  1. Group - This 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 the field selected is in hours, divide the field by 24 hours using the button in the dataset window. Refer to Step 6c below.
  7. Progress
2. On the Timeline tab, configure how the dates appear. By default, the dates are shown weekly for the Top tier and daily for the Bottom tier.
  1. Count - Determines the data that will be shown per unit. For example, if the unit used is day and the count is 2, the data shown will be for Mon - Wed - Fri - Sun, and so on.
  2. Unit - Select Hour, Day, Week, Month, or Year.
  3. Format - Choose among the available date formats in the drop-down field.
Click Apply. This will show a preview of the Gantt Chart widget. Below is an example.