V11 Understanding the SQL/DBF 'Cross-section' Series Type
Uploaded on Aug 16, 2013 / 119 views / 364 impressions / 0 comments
FP11_DLGCHART11 Alpha Five v11 Chart Cross Sectional Data
In most cases, when you plot data from a SQL or .dbf table, your tables are structured so that your query will return a series of values from multiple records, with each value representing a point in a data series. However, in some cases the data in your tables is structured in a "cross-sectional" manner. In other words, the data that represents points in the data series you want to plot comes from multiple fields in a single record, rather than from a single field in multiple records. In order to create charts based on "cross-sectional" data, you define your Data Series using either the SQL or DBF "Cross-section" data series type. This video shows how the data series for this type of chart is defined.