Export Options

Check out the given walk-through on how to use various Export options on the Designer charts.

Exporting Chart

• Navigate to the Designer homepage.

• Click the Dashboard Designer option.

• Click the Add Dashboard option (You can use the New option to create a new dashboard).

• The Dashboard Canvas page opens.

• Click the Data Connectors icon.

• Create a new Data Connection.

• Click the Component Library icon.

• The charts menu opens.

• Select a chart component and drag it to the dashboard canvas. E.g., the Bar chart is used in the image.

• Use the Dataset option to associate the data connection with the dragged charting component.

• Provide the data fields under the Category and Series.

• Open the Component Properties.

• The Export Options are displayed.

• Use a checkmark to enable the Context menu for the Export options.

• The Context menu will appear based on the selected Export options.

• Based on the provided information for the following list the information will get exported:

  • Export Heading

  • Export Sub-Heading

  • Export File Name

  • Global Export Type

  ​​

  
• Navigate to the dashboard preview screen.

• Use the right-click to get the Export Context menu.​

  
• Click on an Export category.

• The Dashboard gets downloaded in the concerned export option.

  
• Click the Print Preview option to print the Dashboard preview.

• Click the Show Data option to display the data in a grid format. ​

  

Please Note:

• While saving a dashboard (for the first time) the user gets the Export option choosing which dashboard gets exported as a BVZX file.

• Legend also gets exported in PDF when associated with a chart.

Export Chart to CSV with Plugin Script

Users can export a chart into CSV using a plugin script as well.

Check out the illustration on how to use a plugin script for exporting a chart data into CSV.

Exporting Data into CSV with plugin script

• Navigate to a dashbord with at least two components. In this case, Bar chart contains mapped data and the Label component is used to map the plugin script.

• Click the script icon to open the dashboard level and component level script page.

• Choose the Label comopnent.

• Enter the plugin script to export the chart data into CSV format.

• The chart data will be exported in a CSV file.

Plugin Script used

var item = sdk.getWidget('component');
item.plugin.m_excelexportext='csv';
item.plugin.exportToCSV();

Please Note: The following old script in use is deprecated.

var item = sdk.getWidget('component');
item.plugin.m_exceleportext = 'csv'
item.plugin.exportToExcel() 

Export with Formatter

The users can export the chart data with formatter to Excel or CSV formats.

Check out the illustration on exporting a chart data into Excel or CSV with Formatter.

Exporting Data to Excel or CSV with Formatter

• Navigate to a dashbaord and select a charting component mapped with some data.

• Open the Formatter properties and define some fomatters for the selected chart.

  • Unit

  • Precision

  • Currency

  • Position

  • Number Formatter

• Make sure that Excel Options are enabled for the chart.

• Click the Preview icon.

• Access the Export context menu in the preview mode with right click.

• Click on Export to Excel and Export to CSV in turns to export the data into Excel or CSV.

• The data will be exported to the .xlsx and .csv files.

• Open the exported Excel & CSV files the data will appear in it with the selected formatter options.

Bar data with Formatter exported to Excel

Bar data with Formatter exported to CSV