Difference between revisions of "Create Graph"

From PresenceWiki
Jump to: navigation, search
(Input Options)
(Stacked Bar Chart)
Line 103: Line 103:
 
*'''Values''' - This should be a reference to the Data Column that contains the values, with one value per category and subcategory (see the above table).
 
*'''Values''' - This should be a reference to the Data Column that contains the values, with one value per category and subcategory (see the above table).
 
*'''Orientation''' - This controls whether bars go from top to bottom (vertical orientation) or left to right (horizontal orientation).
 
*'''Orientation''' - This controls whether bars go from top to bottom (vertical orientation) or left to right (horizontal orientation).
 +
 +
 +
----
 +
 +
==== Meter Chart ====
 +
 +
http://www.international-presence.com/wikidocs/images/meter_graph_icon.png
 +
 +
Meter Charts are useful for displaying a single value as a needle on a dial, and allows you to color-code intervals of the dial to indicate the relative meaning of the sections - for example green, amber and red sections could indicate "low", "medium" and "high" values. Please see the example below:
 +
 +
http://www.international-presence.com/wikidocs/images/meter_chart_example.png

Revision as of 13:47, 16 June 2010

The "Create Graph" Node has been replaced as of Version 3.6 (currently in testing stage) with a new interface. Please note that the new version is not compatible with the old version and so Create Graph Nodes built using the previous versions will need to be redesigned.

Graph Types

At present we provide the ability to create seven different types of graph, although we aim to increase this number in subsequent releases. These are:

  1. Standard Pie Chart
  2. Ring Pie Chart
  3. 3D Pie Chart
  4. Bar Chart
  5. Stacked Bar Chart
  6. Meter Chart
  7. Line Chart

Creating a Graph Node

To create a Graph Node, drag the "Graph Node" icon from the Actions Task Elements list into your Task view. You will then be presented with the Graph Node Editor:

http://www.international-presence.com/wikidocs/images/create_graph_editor_1.png

Graph Type and Data

The first tab allows you to specify the type of chart you wish to create and to enter values for properties that are specific to each type. To select a type of chart click on the appropriate icon from the list on the left hand scroll pane. When a Chart type is selected the options available in the main panel will change, as will the in-line help section.

The next section of this document explains the options available for each chart type.

Pie Chart

http://www.international-presence.com/wikidocs/images/pie_graphs_composite.png

Pie Charts are ideal for displaying comparisons of values between different items - for example, shares of votes in an election, product sales, etc.

This section covers the standard, ring and 3D pie charts (options are identical for each).

  • Label Series Column - The value for this should be a Presence data table reference - e.g. :var{labels}. If we consider a pie graph to consist of name / value pairs, the Labels series contains the names of the items.
  • Values Series Column - Again this should be a Presence data table reference - e.g. :var{values}.
  • Use simple labels? - If checked, labels appear on top of the pie slices instead of outside the pie, which is the default behaviour.
  • Include a legend? - If checked a legend will be displayed at the foot of the chart.
  • Explode Slices - This option allows you to automatically "explode" slices of the pie chart (see image below)

http://www.international-presence.com/wikidocs/images/piechart_exploding.png

Which slices are exploded is determined by the Rules you attribute by clicking the "Set Explosion Rules" button. For example a rule which states :var{value} > 10000 will explode any slices which have a value of greater than 10,000. Please note that this feature is not available for 3D Pie Charts.

  • Labels Format - Determines the format of automatically generated labels. Three special markers - {1}, {2} and {3} - represent the slice name (e.g. Scotland), the actual numeric value (e.g. 557) and the percentage of the total amount (including a percentage sign). Please see the example label formats below:


Label Format Example Output
{0} = {1} ({2}) Paraguay = 7 (13%)
{0} ({2}) Paraguay (13%)
{0} {1} Paraguay 7
{2} 13%



Bar Chart

http://www.international-presence.com/wikidocs/images/bar_chart_icon.png

Bar charts are used for plotting discrete (or 'discontinuous') data i.e. data which has discrete values and is not continuous. Some examples of discontinuous data include 'shoe size' or 'eye colour', for which you would use a bar chart. In contrast, some examples of continuous data would be 'height' or 'weight'. A bar chart is very useful if you are trying to record certain information whether it is continuous or not continuous data.

http://www.international-presence.com/wikidocs/images/bar_chart_options.png

  • X Axis Label - This is the label that appears along the X Axis of the graph - either at the bottom (vertical) or along the left hand side (horizontal). You may use a variable or a column reference, however typically this will be a plain text value (e.g. "Countries")
  • X Axis Series - This is the data series which should be used for the X Axis values. Usually this will be a Presence data column reference, e.g. :var{COUNTRIES}, :var{DATES}, etc. Each available value for the X Axis Series will represent a new bar.
  • Y Axis Label - This is the label that appears along the Y Axis of the graph - either along the left hand side (vertical) or along the top (horizontal). It can be a variable reference, data column reference, or more commonly a plain text value.
  • Y Axis Series - This is the data series which should be used for the Y Axis and determines the length of the bar. This must correspond to a numeric value.
  • Orientation - This determines whether the chart is arranged vertically (with bars going from bottom to top) or horizontally (with bars going left to right) - see the image below for a comparison.


http://www.international-presence.com/wikidocs/images/bar_graph_orientations.png



Stacked Bar Chart

http://www.international-presence.com/wikidocs/images/stacked_bar_chart_icon.png

Stacked Bar Charts involved the concept of Categories of data, where each Category contains measurable attributes which can be quickly compared with each other. For example, imagine you wanted to display the comparative costs of different activities in different company departments. An incoming Data Table for such a scenario may look like this:

http://www.international-presence.com/wikidocs/images/stacked_bar_chart_example_data.png

And the resulting graph would look something like this:

http://www.international-presence.com/wikidocs/images/stacked_bar_chart_example_graph.png

Input Options

http://www.international-presence.com/wikidocs/images/stacked_bar_chart_options.png

  • Categories Label - This is a text label to describe the category set, which appears at the foot of the bars - for example, "Departments". Presence variable references and data column references are permitted, but it is more usual to use a (static) text value.
  • Categories - This is usually a reference to a Presence Data Column, e.g. :var{DEPARTMENT}.
  • Sub Category Label - A text label to describe what is being measured - e.g. "Cost % By Activity".
  • Sub Categories - Typically a Presence Data Column reference which lists the sub categories (in our example, activities) - e.g. :var{ACTIVITY}
  • Values - This should be a reference to the Data Column that contains the values, with one value per category and subcategory (see the above table).
  • Orientation - This controls whether bars go from top to bottom (vertical orientation) or left to right (horizontal orientation).



Meter Chart

http://www.international-presence.com/wikidocs/images/meter_graph_icon.png

Meter Charts are useful for displaying a single value as a needle on a dial, and allows you to color-code intervals of the dial to indicate the relative meaning of the sections - for example green, amber and red sections could indicate "low", "medium" and "high" values. Please see the example below:

http://www.international-presence.com/wikidocs/images/meter_chart_example.png