Home Layouts...Charts

| | !PIECHART | Configure a chart
| !TRACKINGSTATUSPIECHART=SQL! | Configure a simple tracking status chart - SQL must be only 2 columns for status abbrev. and total |

Pie Chart (PIECHART)
Use this merge item to insert a pie chart at the location of this text (will be substituted over the text). The merge-text always begins and ends with a '!' character - after 'PIECHART=' the rest of the text will be in sections delimited by semicolons. The format is always SQL=FirstPieSliceSQL;FirstPieSliceTitle;SecondPieSlideSQL;SecondPieSliceTitle, etc.

For example, take the merge-text below inserted into a Home Layout:

!PIECHART=SQL=SELECT COUNT(*) FROM GAGES WHERE COMPANY = 'ABC COMPANY' AND EVENT_STATUS = 'AC';Awaiting Cal;SQL=SELECT COUNT(*) FROM GAGES WHERE COMPANY = 'ABC COMPANY' AND EVENT_STATUS = 'AR';Awaiting Routing;SQL=SELECT COUNT(*) FROM GAGES WHERE COMPANY = 'ABC COMPANY' AND EVENT_STATUS = 'RTC';Returned To Customer!

Example - PIECHART

This will be replaced in the Home View as:

Example - PIECHART - In Home View

Tracking Status Pie Chart (TRACKINGSTATUSPIECHART)
Use this merge item to insert a pie chart related to tracking statuses at the location of this text (will be substituted over the text). Typically this is a summary of tracking status counts for a grouping of equipment. The data counts for the chart and # of pie wedges are created from the 2 columns in the SELECT - the first field must be EVENT_STATUS, and the second column must be the counts. Use GROUP BY to create a count for each status, as in the example below. This chart is similar to the bar chart that can be shown automatically to the right of a flowchart (see Flowchart Editor - Options, Tracking Statuses, Event Types) but follows an exact SQL command. This chart is NOT interactive (no hyperlinks) - so it is best used simply for a quick visual summary.

For example, take the merge-text below inserted into a Home Layout:

!TRACKINGSTATUSPIECHART=SELECT EVENT_STATUS, COUNT(*) FROM GAGES WHERE COMPANY = 'ABC COMPANY' GROUP BY EVENT_STATUS!

Example - TRACKINGSTATUSPIECHART

This will be replaced in the Home View as:

Example - TRACKINGSTATUSPIECHART - In Home View

Chart Height/Width
For both chart types (PIECHART and TRACKINGSTATUSPIECHART), if you would like to modify the chart's default width and/or height, then this can be accomplished through a System-Wide Preferences variable. See System Preferences - Variables. Two variables can be used - they will control chart height/width for ALL charts in all layouts:

·CHARTWIDTH - input width as 'Integer Value' - Pixels

·CHARTHEIGHT - input height as 'Integer Value' - Pixels |