Search here...
< All Topics
Print

Build Stacked Column Chart

In Prolaborate, users can build Stacked Column charts by any one of the following methods.

  • Build Stacked Column Chart using Designer Configuration
  • Build Stacked Column Chart using SQL Queries
  • Build Stacked Column Chart using Reports

Build Stacked Column Chart using Designer Configuration

Chart designer allows users to create charts with few simple clicks. With a chart designer, charts can be configured by simply selecting the filters. A MDG based sub-report can be added as well to see detailed information by clicking the dissections of the chart.

Chart designer allows users to view the query that was generated by the configurations made, which can be further be edited to create customized charts if required.

In Create Chart Widget, follow the below steps to create a Stacked Column chart using designer configuration.

Basic Details
Field Description
Chart Name Enter a suitable chart name
Choose Chart Type Choose Stacked Column under chart type
Source Selection
Field Description
Browser By clicking on this section, you will be able to view the package
Search Repository To search for packages and elements. Click the Search icon to open the repository search page, where the user can search for elements by name, or the user can choose object type, type, and stereotype from the dropdown menu
Select All Levels When Select All Levels is selected, the sub packages and elements within a package are selected automatically once the user selects the package
Designer Configuration

This section allows the user to select the configuration needed to create a chart.

Field Description
MDG Based Subreport Option enabled by default which allows users to see in-depth information when one clicks the dissections of the chart. It also allows users to filter the report data based on MDG stereotypes available. To know more click here
Specify Type Select the Object type from the dropdown that is available from the package
Specify Stereotype Select the stereotype from the dropdown
Fully Qualified Name By enabling this option, one can see the complete name of the Stereotype with its technology. If not enabled, you will be able to see only the name of the Stereotype
Filter By Property You can filter the elements based on the basic properties i.e., Name, Stereotype, Status, Notes, etc, or tagged values
Condition (on how this works):
User can filter based on the conditions like IN, NOT IN from the tagged value and Basic Properties
Filter values:
Based on the above Tagged value or Basic Property, user can filter in detail by using the values from the Tagged value or basic property
X-Axis Choose the property (basic properties or tagged values) to be plotted in X-axis based on which the chart will be displayed
Group values in X-axis Column in X-axis can be grouped based on basic property or tagged value. If a tagged value is selected, you can further group columns based on the property or its value
Y-Axis Specify how Y-axis or the length of the column needs to be calculated. It can either be based on count or sum of the values specified.

After choosing all the filters click Next.

On the query configuration page, the queries for the designer configuration will be displayed. Users can either customize the query if required by enabling the Edit auto-generated query option or copy the query and use it later for customization.

Note:

  • Enabling this option will result in loss of traceability between the selected designer configuration from the previous page and the query.

Click Next to navigate to the chart settings page.

Users can customize the style and aesthetics of the chart on the Chart Settings page. We’ll go over each feature in more detail later in this article. Now press the Save button.

Build Stacked Column Chart using SQL Queries

In Create Chart Widget, follow the below steps to create a Stacked Column chart using SQL Queries.

Basic Details
Field Description
Chart Name Enter a suitable chart name
Choose Chart Type Choose Stacked Column under chart type

Click Skip to Query option to go straight to the Query Configuration and build the chart by following the below steps.

Query Configuration

This section captures the query required to create the Stacked Column chart. This section consists of Query | Level 1

Field Description
View Sample It displays a sample query with the option to see more
Query Enter the query in the space provided based on requirements
Copy Query Click this button to copy the entire query, with no manual selection required
Execute Click on Execute to see the query’s results
MDG Based Subreport Option enabled by default which allows users to see in-depth information when one clicks the dissections of the chart. It also allows users to filter the report data based on MDG stereotypes available. To know more, click here
Enable Clickable Query By enabling this, the user can enter a clickable query and see the results when the respective section of the chart is clicked.

Note:

  • This option is visible only when MDG Based Subreport is disabled.
Set Placeholder Values Displays the list of placeholders in the query, if there is any. Enter values for the respective placeholders and save them. To know more, click here
Save as Report Save the configurations applied as a report in Report Configuration page where it can be reused again when a new chart is created. To know more, click here
Fetch Result Query Click this button to fetch the result query
Result Query This text box will display the result query upon clicking on the Fetch Result Query

Click Next to navigate to the chart settings page.

Note:

  • To apply colors for individual tagged values that are defined using Color Palette Configuration, an alias ‘seriesproperty’ should be mentioned in the query

Users can customize the style and aesthetics of the chart on the Chart Settings page. We’ll go over each feature in more detail later in this article. Now press the Save button.

Build Stacked Column Chart using Reports

From Prolaborate V4.2.0 and above, charts can be created by using predefined and reusable reports from Report Configuration. To know more about Report Configuration, click here

The created reports from report configuration window can be applied when creating a new chart widget. After choosing the widget type, a popup will appear listing all the available reports.

For EA chart widget, it will display only the query type reports. The level column denotes the number of levels configured in the report.

Report can also be selected by selecting Choose a Report from the dropdown How do you want to build? option.

After selecting the report, choose the required chart type. The configuration will be automatically applied and then click Next to navigate to the chart settings page.

Users can customize the style and aesthetics of the chart on the Chart Settings page. We’ll go over each feature in more detail later in this article. Now press the Save button.

Customize Stacked Column Chart

Chart Preview: This section will show a preview of the chart after the changes have been applied to it.

Refresh Chart Preview: This feature allows you to see a preview of the changes made in the chart settings on the current page. Changes made in the chart settings will be reflected in Chart Preview.

General

Under General section, users can modify the general chart settings based on their needs.

Field Description
Legend Toggling this option will allow the users to show or hide the legend in the chart
Float Legends Enabling this option will display the legend within a box
Information on Hover Enabling this option will display the Info tip of the Element
Legend Ellipsis Long Legend will be displayed only to the extent permitted. Enabling this feature allows the user to see the entire legend when one hovers over it
Legends Position By using this feature, users can place the legend either on the bottom or on the right side of the chart area
Legend Title Enter a suitable title for the legend in the provided space
Use default color from Color Palette Configuration This option will be enabled by default where colors will be applied to the chart either from Color Palette or MDG Color Configuration
Color Range With this feature, users can select any of the predefined color range for their chart
Color code chart based on data With this feature, users can define a customized color code for a specific section of the stacked column chart. To use these settings, enter the legend exactly “as is” in the text box where you want to define a customised color code and choose a color to add. You can also specify different color codes for different legends.

Note:

  • Disable Use default color from Color Palette Configuration option to show both Color Range and Color code chart based on data options

Bar Settings

Bar settings allow you to change the X-axis text angle, Y-axis text angle, font type, font size, font color, etc. Under Chart Settings, you can select Bar Settings.

Field Description
Rotate text on X-axis Select the angle to be applied for the chart’s X-Axis text. Select the desired angle for the texts by clicking the dropdown
Rotate text in Y-axis Select the angle to be applied for the chart’s Y-Axis text. Select the desired angle for the texts by clicking the dropdown
Font Family Select the font to be applied for the chart’s text and numbers. Select the desired font for the text and numbers by clicking the dropdown
Font Size Specify the font size that will be used for the chart’s text and numbers. Select the desired font size for the text and numbers by clicking the dropdown.
Text Color Select the font color that will be used for the chart’s text and numbers. Click the dropdown and select a color from the color palette to apply to the text and numbers.

Graph Settings

Graph settings let you manage labels for the X-axis and Y-axis and their position, minimum space between bars, and width of bars.

Field Description
X-axis Label Fill the X-axis label Name
Y-axis Label Fill the Y-axis label Name
X-axis Label Position Select the angle to be applied for the chart’s X-Axis Label Position by clicking the dropdown
Y-axis Label Position Select the angle to be applied for the chart’s Y-Axis Label Position by clicking the dropdown
Width of Bars By changing the value from this field user can adjust the Bar Width
Minimum Spacing Between Bars By changing the value from this field user can adjust the Minimum Space Between Bars

Display Label Settings

Display setting lets you manage prefix and format numbers.

Field Description
Position Choose the position of the Prefix and Suffix, if they are used in the chart
Prefix/Suffix Add a prefix/suffix before the value which is used in the chart. For example, if you want to represent cost or revenue in the chart, you can use the $ symbol before or after the value
Format Numbers Round numbers to the nearest decimal point

Click Save to save all the configurations.

After clicking save, users can change the size of the widget on the following page by clicking on the bottom right corner of the widget. After resizing the widget’s size, click Save.

The Stacked Column chart has been successfully configured and is now visible on the dashboards page.

Stacked Column Chart Widget Options

Once the chart widget is created, multiple options will be displayed when hovering on it.

Chart Settings

Chart Settings in the widget displays a list of option where users can temporarily modify the look of the chart, download or print the chart, etc.

Show/Hide Legend

This option allows users to show/hide the legends in the chart widget.

Modify View

Modify view option opens the chart settings popup window where users can modify the look and aesthetics of the chart temporarily. This helps users to test the various changes before applying them permanently.

Show/Hide More Options

This option display additional options to print or download the chart widget as an image or PDF document. Click on Show More Options under chart settings and a hamburger icon will be displayed.

Click on it to display multiple options to download the chart widget.

View as Stacked Bar

This option temporarily changes the output of the stacked column chart to a stacked column bars.

Share Widget

To share a widget, hover over a widget and click on the Share icon in the widget. Under the Copy Link to Share dropdown, select the type of link (Public, Private or Embed) to be shared.

Discuss Widget

Discussions can be initiated for a selected widget in the dashboard. To discuss, hover over a widget and click the Discuss icon to open the discussion tab to start a discussion.

The other options in the widget includes refresh, view and maximize or minimize the widget respectively.

sparxsystems-logo-inverted

Start Here
Book a Demo