Exporting Chart and Data

Exporting Chart and Data

Exporting charts and data helps you store/save them in your device or on the cloud. You can then share or view the chart in PDF format and data in CSV format.

Exporting Chart

To export the chart, follow the steps given below.

  1. Create the number of charts as required. Refer to Creating Charts using Widgets.
  2. Select the widget that you want to export.
  3. On the top right corner of the widget, click the More Options ellipsis (  ).
    The available options are displayed.
  4. Click the Export Chart In PDF option.
    The selected widget is saved as a PDF file in your default download folder.

Exporting Data

To export data, follow the steps given below.

  1. Create the number of charts as required. Refer to Creating Charts using Widgets.
  2. Select the widget from which you want to export data.
  3. On the top right corner of the widget, click the More Options ellipsis ( ).

The available options are displayed.

  1. Click the Export Data In CSV
    The data of the selected widget is saved as a CSV file in your default download folder.
    For example, we plot a Column Chart of the Maximum of Sales by Order Priority in a sales dataset, as shown below.



    A snippet of the data stored in the CSV file for the above Column Chart is shown below.



    Now, let’s sort the widget by arranging the Maximum of Sales in the Ascending Order. The resultant widget is as shown below.



    Now, we export the data from the sorted chart as CSV. A snippet of the data is shown below.



    You can see that the data in the new CSV file is also arranged in the same order as the chart, that is, Ascending order.

Notes:

  • Some browsers will ask you to select the location where you want to save your dashboard. Select the destination folder, and then click Save.
  • The Export Data In CSV option is disabled when you drag and drop a widget on the dashboard canvas but have not plotted it.
  • When you download the CSV dataset, the default name of the file is the title name of the widget.
  • In the above example, the default file name is “Maximum of Sales by Order Priority”.
  • For measure quantity, the name of the column in the downloaded CSV has the following format.
    • “measure_name (aggeregated_function_used)”
  • In the above example, since the Sales values are aggregated by the Maximum function, the name of the column is Sales (max).

    • Related Articles

    • Exporting a Dashboard

      Exporting a dashboard helps you to store/save the dashboard on the system. You can then share or view the dashboard in PDF and PPT format. When you export a dashboard, all the pages present in the dashboard are exported. To export a dashboard, follow ...

    • Exporting a Project

      Exporting a project is saving the project on your system. The exported project is saved in a .DAT file format. This project can be used again by importing it into rubiscape. Note: Make sure you are in the correct Workspace, which includes the project ...

    • Exporting Data Dictionary

      You can export the data dictionary to save it to your computer. To export a data dictionary, follow the steps given below. Open the workspace that includes your data dictionary. Refer to Changing Workspace. On the home page, click Datasets. Recent ...

    • Formatting a Chart

      This formatting is applicable for widgets that do not have axes. For example, chart formatting is possible for widgets such as Pie Chart and Donut Chart. To format the chart, follow the steps given below. Create the number of charts as required. ...

    • Unlock Value Axis in Dual Axis Chart

      A secondary value axis (or Line Y-axis) appears when you plot a dual-axis widget (like the Combination Chart containing Columns and Line); a secondary value axis (or Line Y-axis) appears. Many times, the values of data points plotted on the Line ...