N O T I C E
MSPbots WIKI is moving to a new home at support.mspbots.ai to give you the best experience in browsing our Knowledge Base resources and addressing your concerns. Click here
for more info!
Page History
...
- On the MSPbots menu, navigate to Widgets.
- On the Widgets tab, click New Widget.
- Browse the widget types on the New Widget window and select Column Chart.
- 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.
- Go to Dataset and click
sign.
- Click New Layer on the Add New Layer window that appears.
- Do the following on the Dataset window:
- Select a Dataset to use and provide a name for this.
- Add columns by selecting an option from the Column Name dropdown list and assigning an Alias and Business Type for each.
- Click the
icon to add more rows.
- Add filters, measures, and dimensions.
- Choose a value for Order By and input for Row Limit, if necessary.
- Click the Save button.
- Click Apply. This will show a default preview of the column chart that you created.
- Next, go to Config and provide data for the following fields:
- Bar Chart Title - Provide a title for the data being presented.
- Dimension - Select the data for the x-axis (horizontal) of the bar chart.
- Multiple Measure - If this is not selected, the y-axis will have one measure. If selected, there will be multiple measures on the y-axis, such as the left y-axis and the right Y-axis.
- Measure - Select the data for the y-axis (vertical) of the bar chart.
- Measure Color - Select the color for the y-axis of the bar chart.
- Show Column Limit - Set the number of columns to display on the Column Chart. For example, setting it to 3 will display 3 columns.
- Trendline - Select the preferred trendline from the dropdown list, if necessary.
- Label Font Size - Set the font size for the label.
- X-Axis Font Size - Set the font size for the x-axis.
- Set Goal - Provide the preferred set goal, if necessary.
- Goal Color - Select a color for the set goal.
- Measure-lineLine - Select the preferred measure-line from the dropdown list, if necessary necessary.
- Dimension Group - Select the preferred dimension group from the dropdown list, if necessary.
- Type - Select the preferred type of Bar Chart (Stacking StackingColumn, Column, or Column, Bar ) from the dropdown list, if necessary.
- stacked Statistics - Enable this switch to display the column chart using stacked statistics.
- stacked Statistics Sort - Select descending or ascending to sort the stacked statistics.
- 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 Percentage -Selecting this option will display the percentage on the y-axis.
- Right yAxis Coordinate - If selected, it will display the coordinates on the right x-axis.
- Use Right yAxis Measure - Select the measure to be used for the right y-axis.
- Right yAxis Label Name - Enter the label name for the right y-axis.
- Right yAxis Percentage - Select to display the percentage on the right y-axis.
- yAxis NameLocation - Select start, center, or end as the
preferred - location for theMeasure Name
(Start, Center, or End) - from the dropdown list, if necessary.
- yAxis NameGap - Provide the preferred number of gaps forMeasure Name, if necessary.
- yAxis NameRotate - Provide the preferred orientation for Measure Name, if necessary.
- Show Label - The default is to show the labels.
If - Deselect the checkbox for Show Label if you prefer not to show
this, untick the checkbox for Show Label. Tick - these.
- Split Line Show - Select the checkbox for Split Line Show if you wish to show the split lines.
- Label Format - You can configure the Label Format with the following tokens:
- {x_val}: The value of the x-axis
- {x_val2}: The dimension value of the legend
- {y_val}: The total value of the y-axis in the bar chart
- {y_val2}: If a stacked bar chart is selected, this is the value of each part of the y-axis.
- {measure_name}: The name of the y-axis
- Click Apply to save the settings.
- Go to Conditional Formatting. If you want the text color to change when the fields and measures meet specific conditions, set a conditional formatting rule for your column chart. Go to Conditional Formatting and add rules to define the conditions. Once a rule is set, click Apply on the Add a rule window.
- Lastly, click Apply on the widget to show a preview of the column chart.Widget Builder window.
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 column chart.
Overview
Content Tools