fishklion.blogg.se - Quartzbuilder charts

#QUARTZBUILDER CHARTS CODE#

Advanced Options SQL Criteria Optionally enver any valid SQL Where criteria (must be MySQL Useful for organizing the tree view of theĬhart list. Folder Optionally specify the name of the folder to store thisĬhart within. Time Grain (line/bar/column charts) For date-based graphs, the grain of time to display (day, Options are sum, average, count, maximum, and minimum. Operation Choose the type of operation to aggregate your values. For example, Order Amount might be the field,Īnd the operation would then be "sum" or "average." Value The field that will be used to calculate the value to display Metro codes used to designate various regions US codes

#QUARTZBUILDER CHARTS CODE#

An uppercase ISO-3166-2 region code name or itsĮnglish text equivalent (for example, "US-NJ" or "New.

Text equivalent (for example, "GB" or "United Kingdom"). Or an uppercase ISO-3166-1 alpha-2 code or its English

A country name as a string (for example, "England"),.

To transform individual columns into a single series column.

Multiple columns that you want to use as series, please refer When you include a series, ChartBuilder will break Series You can optionally specify a series by which to group yourĭata. If your database column is a date stored asĪn integer, check the Integer Date box. If your x-axis column is a date type, check the Dateĭriven box. X-Axis Select a column from your table/view that will be the horizontal

For common chart types likeīar/column/line charts, here are the key options: Each type of visualization will have unique