InetSoft Report Script for Modifying Graphs

Report script that modifies 'graph' should be placed at the element level. See Adding Element-Level Script.

DataSet.getRowCount()

Returns the number of rows in the DataSet (including the header row).

Example:

importPackage(inetsoft.graph)
importPackage(inetsoft.graph.data)
importPackage(inetsoft.graph.element)
importPackage(inetsoft.graph.aesthetic)
importPackage(inetsoft.graph.guide.form)
 
// Create a chart with two datasets:
var arr = [["State", "Total", "Profit"],
      ["NJ", 200, 25],
      ["NY", 300, 150]];
dataset = new DefaultDataSet(arr);
graph = new EGraph();
var elem1 = new IntervalElement("State", "Total");
var elem2 = new IntervalElement("State", "Profit");
var frame = new StaticColorFrame(java.awt.Color.red);
elem2.setColorFrame(frame);
graph.addElement(elem1);
graph.addElement(elem2);
 
// Loop through the rows of the second dataset (Profit),
// and place labels on the bars.
for (var i=0; i}

DataSet.getColCount()

Returns the number of columns in the DataSet.

Example (Report or Viewsheet):

importPackage(inetsoft.graph)
importPackage(inetsoft.graph.data)
importPackage(inetsoft.graph.element)
importPackage(inetsoft.graph.aesthetic)
importPackage(inetsoft.graph.guide.form)
 
// Create a chart with two datasets:
var arr = [["State", "Total", "Profit"],
      ["NJ", 200, 25],
      ["NY", 300, 150]];
dataset = new DefaultDataSet(arr);
graph = new EGraph();
var elem1 = new IntervalElement("State", "Total");
var elem2 = new IntervalElement("State", "Profit");
var frame = new StaticColorFrame(java.awt.Color.red);
elem2.setColorFrame(frame);
graph.addElement(elem1);
graph.addElement(elem2);

// Loop through the rows and columns,
// and place labels on the bars.
for (var i=0; i

DataSet.setOrder(dim,arr)

Set a manual label ordering for a given dimension field.

Parameters

dim String giving name of the dimension to sort
arr Array of strings with desired label order:
['label1','label2','label3',...]

Example (Report or Viewsheet):

importPackage(inetsoft.graph)
importPackage(inetsoft.graph.data)
importPackage(inetsoft.graph.element)
importPackage(inetsoft.graph.aesthetic)
importPackage(inetsoft.graph.guide.form)
var arr = [["State", "Quantity"], ["NJ", 200],
      ["NY", 300], ["PA", 25]];
dataset = new DefaultDataSet(arr);
dataset.setOrder('State',['PA','NY','NJ']);
graph = new EGraph();
var elem = new IntervalElement("State", "Quantity");
graph.addElement(elem);

More Articles About Reporting

Academic Approach to Data Visualization - It is sort of an academic approach, but it's very approachable. It's not a 600 page book written in Latin. It's something you could read in a couple of days. It's got a lot of pictures in it, of course. And he's written other books as well. So, let's set the bar. Say I have a huge amount of data, and it really doesn't matter. It could be population data. That would be gigabytes of data. It could be gigs of data. It could be terabytes of data. And you know what? Someone shouldn't have to read through that data raw to get the meaning of it, right? It's overwhelming to try to do that. So, what do we do? We aggregate that data...

Credit Score Analytic Metric - Some personal examples of analytic metrics that we're familiar with is we all know something about our credit score. Most of us have no idea what the exact formula is but we know that it's some number 400 and 800 and that the bankers use this as a way of measuring the amount of risk in giving someone a loan, and we know that certain things cause it to go up and down. If you have a credit card with $5,000 limit, you haven't used it for two years, and you cancel the card, your credit score actually goes down which is counterintuitive. You'd think it would go up, but you're getting rid of a line of credit. So, that's a much better measure than just looking at one number, like your assets divided by your liabilities...

Customization Advantage Over ClicData - To begin with, InetSoft has done extremely well in general usage ratings, winning over ClicData in Meets Requirements, Quality of Support and Ease of Doing business with. It's greatest benefit for most users is the speed with which dashboards and reports can be churned out. Also available are the extensive reference videos that elaborate on various 'how to' topics. A mentoring service is also available from InetSoft to kick-start your company's efforts. InetSoft wins big under Quality of Support due to its very responsive support staff, quick resolution to customer problem issues and consistent implementation of reasonable requests...

Four Waves of BI - So if we step back a little bit and look at the evolution of business intelligence, I see that there has been four waves of BI, starting in the '80s. And two of those waves have been all about reporting more or less. And two of the ways have been about analytics. So let's go through these. In the 1980s pretty much BI was summed up in the form of static reports that got printed off and distributed by mail to various offices. They typically answered the question of what happened last month? Well pretty quickly, most people realized that wasn't sufficient to run the business and industrious and ambitious users managed to find information on their own, and that spawned a new industry...

Industries That Use Location Intelligence - Location intelligence has become a vital tool across various industries, leveraging geographical data to enhance decision-making processes and gain valuable insights. In the retail sector, businesses utilize location intelligence for market analysis, site selection, and personalized marketing strategies. The transportation and logistics industry benefits from optimizing routes, tracking assets, and improving supply chain management. Real estate professionals leverage location intelligence for property valuation, market trends analysis, and urban planning. Emergency services, such as fire departments and law enforcement, rely on location intelligence for effective response planning and resource allocation. The healthcare industry uses spatial data for epidemiological studies, disease mapping, and optimizing healthcare facility locations...

Previous: Chart Properties

Next: Graph Object