Page History

...

1. On the MSPbots menu, navigate to Widgets.
   
2. On the Widgets tab, click New Widget.
   
3. Browse the widget types on the New Widget window and select Column Chart.
   
4. When the Widget Builder window opens, provide the following, then click the Apply button.
   • Name - Give the widget a name.
   • Description - Provide a short description.
   • Role - Select User or Admin.
     
5. Go to Dataset and click  sign.
   
6. Click New Layer on the Add New Layer window that appears.
   
7. Do the following on the Dataset window: 
   1. Select a Dataset to use. 
   2. Add columns by selecting an option from the Column Name dropdown list and assigning an Alias and Business Type for each.
   3. Click the icon to add more rows. 
   4. Add filters, measures, and dimensions.
   Image Removed
   2. Click the Save button.
      Image Added
8. Click Apply. This will show a preview of the target card that you created.
9. Next, go to Config and provide data for the following fields:
   • Bar Chart Title - Provide the Bar Chart Title that will indicate the title of a title for the data being presented. 
   • Dimension - Select the data that will be on for the x-axis (horizontal) of the bar chart. 
   • Measure - Select the data that will be on for the y-axis (vertical) of the bar chart. 
   • Measure Color - Select the color for the y-axis of the bar chart. 
   • Trendline - Select the preferred trendline from the dropdown list, if necessary. 
   • Set Goal - Provide the preferred set goal, if necessary. 
   • Goal Color - Select a color for the set goal. 
   • Measure-line - Select the preferred measure-line from the dropdown list, if necessary 
   • Dimension Group - Select the preferred dimension group from the dropdown list, if necessary. 
   • Type - Select the preferred type of Bar Chart (Stacking Column, or Column, Bar) from the dropdown list, if necessary. 
   • Dimension Name - Provide a name for the x-axis of the bar chart. 
   • Measure Name - Provide a name for the y-axis of the bar chart. 
   • yAxis NameLocation - Select the preferred location for the Measure Name (Start, Center, or End) from the dropdown list, if necessary.
   • yAxis NameGap - Provide the preferred number of gap gaps for Measure Name, if necessary. 
   • yAxis NameRotate - Provide the preferred orientation for Measure Name, if necessary.
     
10. If you want the text or background color to change when the fields and measures meet specific conditions, set a conditional formatting rule for your target card. Go to Conditional Formatting and add rules to define the conditions. Once a rule has been set, click Apply on the widget rule window.
    Image Modified

...

1. Lastly, click 

...

1. Apply on the widget to show a preview of the widget.