Dashboards, Applications & Business Intelligence

Here is a sneak peek at some of the new charting features and options that are coming for InfoCaptor.

Steps to create the following charts.

1. For Bar, Stacked, Area and Line charts the SQL query should return 3 columns

select building_name,section ,sum(max_size) from "Class"
where building_name like 'B%'
group by building_name, section

The first and second column should be character and the third column should be numeric.

If you have a query that has only two columns (one character and second numeric), then introduce a dummy column in your SQL query with a fixed value

for e.g select char_column1, 'XYZ', number_column from some_table

For Pie and Ring chart, you just need two columns, one character and second numeric.

You can change the angle of the X-Axis labels by modifying the “xAxisLabelAngle” property. Typical values are 30, 45, 60 degrees but you may use any angle.

You can choose to display Item Labels within the displayed graph and also modify the fonts and style of the item labels. You can also modify the number formatting for the item labesl. see below chart editor section.

“DisplayItemLabels”
“ItemLabelFont”
“ItemLabelFormat”

Chart Editor and Options

You would need to change the following property to change the outlook of any charts

“Name”
“Connection”
“MaxRows”

“ChartType”
“xAxis”

“yAxis”

“DisplayLegend”
“DisplayTooltips”

“PlotOrientation”
“xAxisLabelAngle”
“DisplayItemLabels”
“ItemLabelFont”
“ItemLabelFormat”