InetSoft Product Information: Dashboard Reporting API

Changing Chart Scaling

A Scale object determines how abstract data values are mapped to physical chart representations such as position, color, shape, etc. The EGraph object and the VisualFrame object both map data values to physical representations, so both of these objects require a Scale.

Changing Scaling for Chart Axes

See Also Changing Axis Properties, for examples of other axis modifications. To change the scaling of chart axes, simply assign a new Scale to the Chart object. For example, consider the following chart:

 importPackage(inetsoft.graph)
 importPackage(inetsoft.graph.data)
 importPackage(inetsoft.graph.element)
 importPackage(inetsoft.graph.scale)
 var arr = [["State","Quantity"], ["CA",200], ["NY",3000]];
 dataset = DefaultDataSet(arr) graph = new EGraph();
 var elem = new IntervalElement("State", "Quantity");
 graph.addElement(elem);
top ranked BI
Read how InetSoft was rated #1 for user adoption in G2 Crowd's user survey-based index.

Note that in this chart the IntervalElement object implicitly defines a linear Y-axis scale. However, the data values on the chart are widely different in magnitude, which suggests that a log scale might be more appropriate.

To change the Y-axis to use a log scale, follow these steps:

1. Define the desired Scale object explicitly. In this case, create a LogScale based on the 'Quantity' field.

var scale = new LogScale("Quantity");
2. Assign the new scale to the Y-axis of the chart object using the setScale() method.

graph.setScale("Quantity",scale); The complete script with the new chart scaling looks like this:

 importPackage(inetsoft.graph)
 importPackage(inetsoft.graph.element)
 importPackage(inetsoft.graph.scale)
 importPackage(inetsoft.graph.data)
   var arr = [["State","Quantity"], ["CA",200], ["NY",3000]];
 dataset = new DefaultDataSet(arr);
 graph = new EGraph();
 var elem = new IntervalElement("State", "Quantity");
 var scale = new LogScale("Quantity");
 graph.addElement(elem);
 graph.setScale("Quantity",scale);
  

InetSoft Viewpoint

The open standards aspect is very important to us since it allows our customers to integrate our technology more easily and leverage assets they already have, in terms of hardware and software and IT skills. So based on this BI platform, our software delivers a host of front-end BI tools including visualization tools, enterprise reporting, monitoring dashboards, and analysis. Those functions were based on a very powerful patent-pending technology we call Data Block.

This Data Block technology is really made up of a back-end data mashup engine and a caching middle layer. There is a front-end we call the worksheet, which is a Web-based, spreadsheet-like user interface that a power user can easily use to combine and transform data blocks. The data blocks are typically started at the atomic data block level. That is typically created by an IT or a BI specialist. They choose these data blocks and performance tune those data blocks.

Then the power users can use those building blocks to build more complex, but more useful structures for answering the questions they have on hand. And all the data blocks you build, in turn become building blocks themselves. You can build on this architecture, building very sophisticated structures which you can use to answer a wide range of unanticipatible questions.

why select InetSoft
“Flexible product with great training and support. The product has been very useful for quickly creating dashboards and data views. Support and training has always been available to us and quick to respond.
- George R, Information Technology Specialist at Sonepar USA