Upland Community LoginVeuillez noter que ce guide est présentement disponible en anglais seulement.   

Create a Stacked-Bar Graph

A Stacked-Bar Graph is a variant of the Bar Graph. A standard bar chart compares individual data points with each other. A Stacked-Bar Graph (or stacked-bar chart) is a chart that uses bars to show comparisons between categories of data, but with the ability to break down and compare parts of a whole. Each bar in the chart represents a whole, and segments in the chart represent different parts or categories of that whole.

1. Create Report

Access the Create Report modal by:

  1. Click the Create button on the Main Menu Bar.
  2. Then select Report from the menu.

2. Select your Data Source

  1. Select your data source from the list of available data sources to get started.
  2. Click Next to continue.
Note: Data sources in this step are provided for example only. Your Data Sources will depend on the modules licensed and the permissions granted. For more information click here.

3. Add a Report Title

  • Click on the Add report name box and type the name of your report.

4. Select a Report Type

  1. Click the arrow button next to Select report type.
  2. Select Stacked-Bar from the list of available report types to get started.

5. Select a Folder

  1. Click the Save In arrow to view and select an available folder where your graph will be saved.
  2. Do one of the following to make your selection:
    • Choose or create folder: Enter values in this box to filter and find the folder where your graph will be saved.
    • Click the arrow and select Add New Folder to create a new folder where your graph will be saved. See Create a Folder below.

  1. In the Folder Name box, type your new folder name.
  2. Select the desired Parent Folder from the list.
  3. Select your Folder Visibility:
    • Public: By default, this option is selected. This option allows your folder to be viewed by all users.
    • Private: This option will allow you to hide your folder from other users.
    • Share: This option allows you to set your folder to be viewed by specific user(s).
  4. Click Create to create your new folder or Cancel to return to the previous page.

6. Filter or Search for Data Fields

  1. Select the desired Filter to apply to the list of available Fields. The available options are:
    • All Fields
    • Dimensions
    • Measures
    • Date
  2. Start typing in the Search item box to begin searching for available Fields.
  3. You can alternate between Fields and Custom Fields by clicking on either one of the tabs.
    Tip: For more information on how to create and use Custom Fields please refer to: Create and Use Custom Fields
  4. Click Expand All or Collapse All to view or hide all available options in order to easily narrow down on the desired field(s).

7. Select your Data Field(s)

  1. The Data Points section defines the X-Axis Data Set in your Graph. Drop one non-numeric Field to define the main category on the X-Axis (horizontally).
  2. The Data section defines the X-Axis Data Set in your Graph. Drop one numeric Field as the subdivision on each column (X-Axis).
  3. The Stack Data by section defines the s Y-Axis Data Set. Drop one numeric Field or Date Field, to define the value range on the Y-Axis (vertically).
Note: Data Dimensions will appear based on the selected Report Type.

8. Add a Filter (Optional)

  1. Click the Ellipsis button of a Field added to Data Points, Data or Group By sections.
  2. Select Filter Options from the context menu.
Note: For more information on how to create a Filter please refer to this article: Add Filter(s) in a Report

9. Add a Pivot (Optional)

  1. Click the Ellipsis button of the Field(s) added.
  2. Select Pivot Measure from the context menu.

  1. Begin typing the Alias name of your column in the Column Name box .
  2. Select one of the following:
    • Multi Column: By default, Multi Column is selected. Presents your pivot value within multiple columns.
    • Single Column: Presents your pivot value in one column.
  3. Click or type the desired Pivot on Dimension.
  4. Click or type the desired measure.
  5. Click or type the desired Group By.
  6. Click the Add button to add a new Pivot option.
  7. Click Apply to save your changes and return to the previous page. Alternately you can Cancel your changes and return to previous page.

10. Add an Overlay (optional)

You can change the overlay of your stacked-bar graph from columns to lines and display columns and lines all on one graph.

  1. Click the Settings button on the Main Menu Bar.
  2. Select Settings from the menu.
  3. Click the Overlay tab.

  4. In the Display Format column, select Line for the series that you want to display as a line.
  5. Click the arrow in the Merge axis with column for the series that you want to merge and select a series to merge with from the available options. This functionality is useful when data is shown on two of the same axis.
  6. Click Save.

11. Preview Report

  • Click the Preview button to preview your report.
Note: You can Preview your report at any time by clicking on the Preview button. No Data Available displays when there is no data retrieved/found.

12. Save Report

  1. Click Save to open the Save context menu
  2. Choose one of the available Save options:
    • Save: Selecting this option will save the report without exiting the report edit page.
    • Save as copy: Selecting this option will save a copy of the report. You will need to rename the report in the Navigation Menu.
    • Save & Close: Selecting this option will save the report and close the report edit page. The report will then run.
    • Save & send by email: Selecting this option will save the report and close the report edit page. A modal window will then give you the options to send the report. For more information refer to Email a Graph/Chart.
    • Save & Create new: Selecting this option will save the report and close the report edit page giving you the option to create a new report.
Note: A message will appear that your graph has been generated.

Menu