Scripting Dashboard Charts

InetSoft's dashboard software allows users to script charts that represent complex data so the most subtle changes to be easily recognized. View the example below to learn more about the Style Intelligence solution.

Charts offer the same expression property scripting as other Viewsheet components. In addition, a comprehensive charting API gives scripting access to all aspects of a chart, including data binding, chart type, dimensions, measures, and aesthetics.

The following sections explain how to edit chart API scripts, and review the different aspects of charts that can be modified.

To modify a chart using script, follow the steps below.

Do not select 'Plot Properties', 'Axis Prop­erties', etc.

1. Right-click on the chart you wish to modify, and select 'Properties' from the context menu. This opens the 'Chart Properties' dialog box.
2. Click the Script tab. Below the 'Script' panel, click the 'Edit' button. This opens the Formula Editor.
3. In the Formula Editor, enter the desired script. For example, the following script creates a bar chart based on a Data Block called 'LimitedProducts'.
4. Click 'OK' to close the Formula Editor, and click 'OK' to close the 'Chart Properties'.

The chart scripting API allows you to create a new chart from the ground-up. This requires several general steps, described below.

1. Add a new Chart component to the Viewsheet.
2. (Optional) Import the packages required by your script. You only need to import the packages that the script actually uses.
3. Define the data: Define the dataset for the chart using the special keyword “dataset”.
4. Create the Chart object. Create a new chart using the EGraph constructor and the special “graph” keyword.
5. Create the chart data elements. Pass the field names (column headers) to a Graph Element constructor. This creates the representational elements for the chart.
6. Add the elements to the Chart object. Pass the GraphElement object to the Chart's add Element() method. This adds the “bar” elements to the existing Chart object.

More Articles About Dashboards

Evaluate InetSoft's Inventory Management Dashboard Software - Are you researching good inventory management dashboard software? InetSoft's pioneering BI application produces great-looking dashboards that maximize self-service for managers and analysts. View a demo and try interactive examples. All new customers get mentoring assistance for free to speed up their project delivery...

Report Designer Configuration - Basic properties of Report Designer can be specified in the 'Designer Configuration' dialog box. These properties include the locations where Report Designer looks for database and resource information, the appearance of the Report Designer interface, and Report Designer's auto-save behavior. Accessing Configuration Options To open the 'Designer Configuration' dialog box, select 'Configure' from the 'File' menu...

What Are the Operations of OLAP? - OLAP (Online Analytical Processing) is a multidimensional analysis and reporting technology that enables businesses to quickly analyze and explore their data. OLAP operations can be classified into two categories: Slice and Dice and Roll-up and Drill-down. Slice and Dice: "Slice and Dice" operations allow users to analyze data from different perspectives. They involve selecting a subset of data from a multidimensional dataset based on one or more criteria. The two types of "Slice and Dice" operations are: Slice: This operation involves selecting a single dimension from the OLAP cube to slice the data along that dimension. For example, a user can slice the data by selecting only the data for a particular region or time period...

Who Chooses MariaDB for Their Database for Reporting Needs? - MariaDB is chosen by a wide range of organizations, from small businesses to large enterprises, across various industries. Here are some examples of the types of organizations that choose MariaDB for their database needs: Startups and Small Businesses: Startups and small businesses often choose MariaDB for its open-source nature, cost-effectiveness, and ease of use. It provides a reliable and scalable database solution without the high licensing costs associated with proprietary databases like Oracle. Midsize Enterprises: Midsize enterprises appreciate MariaDB's flexibility, performance, and compatibility with existing applications and infrastructure. It offers features such as high availability, replication, and clustering, making it suitable for mission-critical applications and workloads...