Page History

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

...

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.

To make a Gantt chart widget

Navigate to Widgets on the MSPbots app menu.
Image Modified
Under My Widgets, click New Widget.
Image Modified
Select the Gantt widget type on the New Widget window.
Image RemovedImage Added
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.
  Image RemovedImage Added
Next, go to the Dataset tab. Click the button and select New Layer.
Image Removed
Image AddedImage Added
Image RemovedOn 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.
    Image Added
  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?
    Image Added
  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. 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.
7. 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.
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

Additionally, go to the Condition tab to set Conditional Formatting.

Add a rule and assign a name.
Image Removed

Set the conditions for the rule.

Image Removed

Select the text color to be applied once conditions are satisfied.

1. 1. Click Save.
Next, go to the Config tab.
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 Image Added button in the dataset window. Refer to Step 6c below.
  7. Progress
    Image Added
2. On the Timeline tab,configure how the dates will be shown. By default, the dates are shown weekly for Top tier and daily for 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.