InetSoft Product Information: Dashboard Software - Accessing Dashboard Data

InetSoft's dashboard software allows users to access dashboard data from multiple sources and integrate them into a coherent analytical model. View the example below to learn more about the Style Intelligence solution.

In both chart and property scripting, you have explicit access to the data contained in the Worksheet Data Block. The following sections explain the syntax for accessing the Worksheet data.
Within a Viewsheet script, you can use the standard Worksheet syntax to access data from any Worksheet Data Block within the linked Worksheet.

For example, to access a value in a Worksheet Table or Embedded Table called “TopSales”, use one of the following syntaxes.

Note: In general, Data Block operations should be performed in the Worksheet rather than the Viewsheet.
• TopSales[2][4]:
Third row, fifth column of the Data Block “TopSales.”
• TopSales[2]['Price']:
Third row of the "Price" field in the Data Block “TopSales.”
• viewsheet["Top Sales"][2][4]:

Third row, fifth column of the Data Block “TopSales” (with space in name). You can type these keywords manually into your script, or you can insert them by clicking the appropriate node on the 'Data' tree in the Script Editor.

 

View a five-minute Flash demo to get an overview of what InetSoft's business intelligence software, Style Intelligence, can do and how easy it is to use.

 

 

 

 

 

To aggregate data from the Worksheet's Data Block within Viewsheet script, use the following syntax:
aggregateMethod(DataBlockName['ColumnName'])

Note: In general, Data Block operations should be performed in the Worksheet rather than the Viewsheet.

For example, to obtain the sum or average of the Data Block column 'Price', use the following expressions:
var sumPrice = Sum(TopSales['Price'])
var avePrice = Average(TopSales['Price'])

To reference a Data Block that has a space in the name (e.g., “Top Sales”), use the viewsheet keyword as follows: var avePrice = Average(viewsheet[ "Top Sales"]['Price'])

 

Evaluate InetSoft's Business Intelligence Software for your reporting software needs.

 

Previous: Mixed Dashboard Data

Next: Changing Dashboard Images

InetSoft Viewpoint

"if you look at effective deployment of BI and performance management software, it has to be aligned within those business processes. That means the strategy has to be inserted into the DNA of these business processes. That’s number one. Number two is organizations in the last years have increasingly focused on growth. Remember how in 2000 a lot of focus was on cost control. Now, the focus again is on growth. And growth really happens through innovations called business network transformation. Business network transformation is happening with many products, and the pace of change is ever increasing. To give you some quantifiable examples, a new acquisition is happening at every 20 minutes, and a new product is launched every 3.5 minutes. Really to be sustainable advantage there needs to be a business model or network change." - Luke Liang, CEO, InetSoft

Related Links:

		Style Scope - Dashboarding Solution
		Dashboards for Every Industry

More Resources:

		Download a Free Trial
		Embeddable Dashboards for ASPs, ISVs and SaaS Providers
		Bulding Sophisticated BI Dashboards
		Leading Dashboard Software Vendors: InetSoft