Charting

1010data provides a mechanism to generate high-quality charts, which in turn can support the notion of visual data discovery.

Charting helps us make sense of large amounts of data that might otherwise be too overwhelming to comprehend. Imagine a table with 20 columns and 100,000 rows of data. With 2 million pieces of important information right in front of you, it might be difficult to get a clear picture of what it all means. With charting, you can more easily see relationships among the data points so you can quickly glean insights and use them to improve your business.

Numerous chart types are supported in 1010data, including two-dimensional bar charts, pie charts, histograms, and bubble charts, as well as three-dimensional scatter charts and surface charts. In addition, stacked, stepped, and percentile bar chart types are provided. A number of chart types for visualizing financial data are also available, including Kagi, Renko, and candlestick charts. All chart types allow full aspect ratio rendering, so that the chart will fill the whole area when you resize the chart window.

Useful charts can be created with minimal effort using the 1010data web interface by applying one of the provided chart types to the current table or worksheet. You can use the Chart Builder to select the columns of data to be plotted and provide other chart-related parameters, such as the number of samples for a chart. You can select one of the predefined themes to display your chart or graph with a particular color palette, or you can modify individual attributes such as the color, style, or size of the title font; the degree of rotation for the ticks along a particular axis; or whether a legend should be included and where it should appear in relation to the chart.

Figure: "Excel" theme
Figure: "Happy" theme

Once a chart is created, a graphics widget can be generated containing the underlying Macro Language code, which can then be used in the development of a QuickApp. You can edit the XML directly and modify a chart by manipulating the appropriate 1010data Macro Language elements and attributes; or, once familiar with the graphics-related XML, you can build your own charts from scratch.

Figure: Example of a QuickApp created from the Chart Builder
<note type="base">Applied to table: pub.fin.fred2.bls.smsu</note>
<widget class_="graphics">
  <sel value="(state='PA')"/>
  <sel value="between(month;'1/76';'12/90')"/>
  <graphspec width="1008" height="631" theme="happy">
    <chart type="line" title="Monthly Unemployment - Pennsylvania">
      <data x="month" y="unemp"/>
    </chart>
  </graphspec>
</widget>

Charts can be saved along with the associated tables or worksheets as a Quick Query, preserving their settings and attributes as well as the state of the table or worksheet with which they are associated. The Quick Query can be run at a later time, allowing further modifications to the charts contained within.

For each table, you can have multiple charts, allowing you to branch off different paths of analysis. You can also freeze a chart, essentially memorizing the current state of the table. The chart will remain in that state, regardless of any changes to the table with which it is associated, until you unfreeze it, at which point it will sync back up with the current state of the table.

You can also export any of your charts in PDF format, making your data available for internal or external business reports.