LongJump Support Wiki

Difference between revisions of "Charts"

From LongJump Support Wiki
imported>Aeric
m (Text replace - '#Click '''Save'''' to '#Click '''[Save]'''')
 
imported>Aeric
 
(34 intermediate revisions by the same user not shown)
Line 26: Line 26:


The following features are available in charts:
The following features are available in charts:
*Choose the chart type: Pie, Doughnut, Funnel, Line, Area, Bar Chart, Meter Gauge
*Choose the chart type: Pie, Funnel, Line, Area, Bar Chart, Meter Gauge
*Choose the data set to include in the chart (X-Axis and Y-Axis)
*Choose the data set to include in the chart (X-Axis and Y-Axis)
*Choose the chart size (height and width), title, legend, orientation, location, etc., as appropriate for the chart type
*Choose the chart size (height and width), title, legend, orientation, location, etc., as appropriate for the chart type
Line 34: Line 34:


==X-Axis and Y-Axis in Charts==
==X-Axis and Y-Axis in Charts==
*The X-Axis displays values horizontally (left-right)
X-Axis options in charts are defined via the [[Report Group|Group]] tab
*The Y-Axis displays values vertically (up-down)
Y-Axis options in charts are defined via the [[Report Compute|Compute]] tab


===X-Axis===
===X-Axis===
;Selecting X-Axis Options:
:* The X-Axis displays values horizontally (left-right).
:* X-Axis options in charts are defined via the [[Report Group|Group]] tab
 
To select X-Axis Options:
#From the [[Report Fields|Fields]] tab, select fields to display in the report
#From the [[Report Fields|Fields]] tab, select fields to display in the report
#From the [[Report Group|Group]] tab, use the ''Row Group'' section to create X-Axis options
#From the [[Report Group|Group]] tab, use the ''Row Group'' section to create X-Axis options


===Y-Axis===
===Y-Axis===
;Selecting Y-Axis Options:
:* The Y-Axis displays values vertically (up-down)
:* Y-Axis options in charts are defined via the [[Report Compute|Compute]] tab
 
To select Y-Axis Options:
#From the [[Report Compute|Compute]] tab, click the checkbox [[File:checkboxicon.gif|link=]] icon to select available  Y-Axis field(s)
#From the [[Report Compute|Compute]] tab, click the checkbox [[File:checkboxicon.gif|link=]] icon to select available  Y-Axis field(s)
#*Fields that have a Numeric [[Return Type]] (i.e., Number (integer or decimal), Percent or Currency) are displayed in the Compute grid, and become available as Y-Axis options
#*Fields that have a Numeric [[Return Type]] (i.e., Number (integer or decimal), Percent or Currency) are displayed in the Compute grid, and become available as Y-Axis options
Line 51: Line 53:


==Advanced Options for Charts==
==Advanced Options for Charts==
<!--[[File:Chartlegend.gif|right|thumb|Legend located on the Right]]The Legend uses color codes to identify chart elements.-->
The choices in the Advanced Options section depends on the type of chart.
 
===Common Options===
These options are available in every chart:
:*'''Title:''' Chart Title
 
:*'''Size:''' The chart size: Small, Medium, Large or Custom
::If ''Custom'' is selected:
:::'''Height:''' Height of the chart, in pixels
:::'''Width:''' Width of the chart, in pixels
 
:*'''Chart Location:''' Above or Below the data table
 
===Advanced Options for Pie Charts and Funnel Charts===
:*'''Color Palette:''' Comma separated list of one or more hexadecimal color values, used one after the other. For example: <tt>#ff0000,#0a68dd,...</tt><br>''Learn more:'' [http://www.w3schools.com/html/html_colors.asp HTML Colors]
 
:*'''Legend Position:''' Right, Bottom, Hide
 
===Advanced Options for Bar Charts===
:*'''Bar Color:''' Different color, Same color
::Determines whether each bar in the chart displays with the same or a different color
 
{{:Common:Chart Options}}
 
:*'''Data Value Position:''' Inside or outside the data column.
 
===Advanced Options for Line Charts===
{{:Common:Chart Options}}
 
==== <span id="multiline">MultiLine Charts</span>====
: When a chart specifies a grouping on the X-axis, multiple variables can be selected on the Y-axis. Each selected variable produces a line in the chart, connecting the values for that variable for each group.


The available Advanced Options choices differ based on the chart type selected:
::'''Note:''' Multiline charts are supported only for single level Row Grouping.
:*Title: Chart Title
:*Size: The chart size: Small, Medium, Large or Custom
::If ''Custom'' is selected, complete the following information:
:::Height: Height of the chart, in pixels
:::Width: Width of the chart, in pixels
:*Chart Location: Above or Below the data table
:*Value Labels: Show or hide the labels
:*X-Axis Label: Show or hide the label
:*Y-Axis Label: Show or hide the label
:*Y Axis Number Format: Shown for vertical bar, line, and area charts
:*X Axis Number Format: Shown for horizontal bar charts
:*Y-Axis Ticks: The number of ticks displayed
:*X Axis Tick Angle
:*Y-Axis Maximum Range
:*Bar Width(px)
:*Bar Padding(px)
:*Bar Margin(px)
:*Markers: Show or hide the markers
:*Shadows: Show or hide shadows
:*Legend Position
:*Legend Row: The number of rows in the legend
:*Legend Columns: The number of columns in the legend
:*Trend Line: Show or hide the trend line
:*Gauge Start Value
:*Gauge End Value
:*Chart Border: Show or hide the chart border
:*Chart Labels: Show Values, Show Percentages, None
:*Chart Label Position


:For example, this chart is grouped by Last Name on the X-axis, showing values for price, sales, and units on the Y-axis:
::[[File:MultiLineChart.png]]


<!--{| border="0" cellpadding="15" cellspacing="15"-->
===Advanced Meter Gauge Options===
<!--|[[File:chartontop.gif|none|thumb|Chart on Top, above data table]]||[[File:chartonbottom.gif|none|thumb|Chart on Bottom, below data table]]
:*'''Value Labels:''' Show or Hide
|}-->
:*'''Gauge End Value'''

Latest revision as of 21:49, 30 May 2013

Charting options provide the ability to create graphical representations of your data in Reports.

Add a Chart to a Report

  1. In a new or existing Report, click the [Group] tab
  2. In the Row Group section, select one or two fields to define grouping
    • Charts can contain information grouped by one or two levels
    • Column grouping is not used in Charts
  3. Click the Chart tab and select the type, size and location for the chart you want to display
    Learn more: Customizing Charts
  4. Enter Title, Size and Legend information
  5. Click the [Preview] button to check that the chart displays as intended
  6. Click [Save]

Customizing Charts

The following features are available in charts:

  • Choose the chart type: Pie, Funnel, Line, Area, Bar Chart, Meter Gauge
  • Choose the data set to include in the chart (X-Axis and Y-Axis)
  • Choose the chart size (height and width), title, legend, orientation, location, etc., as appropriate for the chart type

Chart Formats

Available chart formats for Reports:

  • Pie Chart

  • Funnel Chart

  • Vertical Bar Chart

  • Horizontal Bar Chart

  • Line Graph

  • Meter Gauge

  • Vertical Stacked Bar Chart

  • Horizontal Stacked Bar Chart

  • Vertical Grouped Bar Chart

  • Horizontal Grouped Bar Chart

X-Axis and Y-Axis in Charts

X-Axis

  • The X-Axis displays values horizontally (left-right).
  • X-Axis options in charts are defined via the Group tab

To select X-Axis Options:

  1. From the Fields tab, select fields to display in the report
  2. From the Group tab, use the Row Group section to create X-Axis options

Y-Axis

  • The Y-Axis displays values vertically (up-down)
  • Y-Axis options in charts are defined via the Compute tab

To select Y-Axis Options:

  1. From the Compute tab, click the checkbox Checkboxicon.gif icon to select available Y-Axis field(s)
    • Fields that have a Numeric Return Type (i.e., Number (integer or decimal), Percent or Currency) are displayed in the Compute grid, and become available as Y-Axis options
    • The options for these fields are Total, Average, Minimum, and Maximum

Advanced Options for Charts

The choices in the Advanced Options section depends on the type of chart.

Common Options

These options are available in every chart:

  • Title: Chart Title
  • Size: The chart size: Small, Medium, Large or Custom
If Custom is selected:
Height: Height of the chart, in pixels
Width: Width of the chart, in pixels
  • Chart Location: Above or Below the data table

Advanced Options for Pie Charts and Funnel Charts

  • Color Palette: Comma separated list of one or more hexadecimal color values, used one after the other. For example: #ff0000,#0a68dd,...
    Learn more: HTML Colors
  • Legend Position: Right, Bottom, Hide

Advanced Options for Bar Charts

  • Bar Color: Different color, Same color
Determines whether each bar in the chart displays with the same or a different color
  • Color Palette:
Comma separated list of one or more hexadecimal color values, used one after the other for bar chart colors. For example: #ff0000,#0a68dd,...
Learn more: HTML Colors
  • Value Labels: Show or hide the labels
  • X-Axis Label:
    • Auto - Let the system decide the best way to show the labels.
    • Wrapped - Keep labels short, wrapping text as needed
    • 90 degree - Write the labels going upwards, instead of horizontally
    • Slanted - Angle the labels for readability
    • Staggered - Offset the labels, so they can be slightly longer without overlapping
  • Data Value:
    • Normal - In line with the data (best for a horizontal bar chart)
    • 90 degree - at 90 degrees to the data (best for vertical bar or line chart)
  • Data Value Position: Inside or outside the data column.

Advanced Options for Line Charts

  • Color Palette:
Comma separated list of one or more hexadecimal color values, used one after the other for bar chart colors. For example: #ff0000,#0a68dd,...
Learn more: HTML Colors
  • Value Labels: Show or hide the labels
  • X-Axis Label:
    • Auto - Let the system decide the best way to show the labels.
    • Wrapped - Keep labels short, wrapping text as needed
    • 90 degree - Write the labels going upwards, instead of horizontally
    • Slanted - Angle the labels for readability
    • Staggered - Offset the labels, so they can be slightly longer without overlapping
  • Data Value:
    • Normal - In line with the data (best for a horizontal bar chart)
    • 90 degree - at 90 degrees to the data (best for vertical bar or line chart)

MultiLine Charts

When a chart specifies a grouping on the X-axis, multiple variables can be selected on the Y-axis. Each selected variable produces a line in the chart, connecting the values for that variable for each group.
Note: Multiline charts are supported only for single level Row Grouping.
For example, this chart is grouped by Last Name on the X-axis, showing values for price, sales, and units on the Y-axis:
MultiLineChart.png

Advanced Meter Gauge Options

  • Value Labels: Show or Hide
  • Gauge End Value
Retrieved from "https://agileappscloud.info/ljwiki-src/index.php?title=Charts&oldid=2468"