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

Create a Line Graph

A Line Graph displays a series as a set of points connected by a single line. Line charts are used to representing large amounts of data that occur over a continuous period of time and can be used to show many different categories of data.

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 your Line 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 different points that will conform your line(s), in relation to your data set on the Y-Axis.
  2. The Data section defines the Y-Axis Data Set in your Graph. Drop the numeric Fields that will define the values on the Y-Axis (vertically), in relation to your Data Points.
  3. In the Group by section, drop one non-numeric Field to define the main category on the X-Axis (horizontally).
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. 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.

11. 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