Report Item: Detail Data Chart | GideonSoft Support
Welcome to our Knowledge Base
< All Topics
Print

Report Item: Detail Data Chart

This is a flexible way to display data as a Line Chart, Pie Chart, Bar Chart or Word Cloud. For those who have used previous versions of GideonSoft, this replaces the Line Chart card. Any reports that utilize the Line Chart will still function as normal, but you can no longer add a line chart item to a report from the report card item gallery. If you edit a line chart item, it will be automatically converted into a Detail Data Chart (preserving all the previously configured properties.)

 

General Options

  • Columns … Select how many columns (up to 4) are used for display.

Data Settings

  • Data Source … This selection affects options such as the Series Field and Value Field below.
    • Evaluations
    • Observations
    • Scores
    • Survey Evaluations
    • Roster
  • Person Filter Options …
    • As Target only
    • As Evaluator Only
    • As Target or Evaluator
  • Text to display when no data exists
  • Data Filters … Begin by clicking ‘Add Criteria’.
    • Select an item from the Field drop down, and Operator and a Value to filter down the list of items that will be displayed.
    • Click Save.

Chart Settings

Most of the options available in the single value versions of the charts are used for the detail data version with some exceptions. Use Chart Type to select one of the possible visualizations. Different options may appear, depending upon the chart type selected.

 

Bar Chart

  • Style … Individual Bars, Individual Grouped Bars, or Stacked Bars
  • Series Field … Select what categories the bars will represent.
  • Value Field … Select the value represented by the height of the bars
  • Value Summary Function … Average, Sum, Count, Min, Max
  • Value Label … Toggle on and provide a label
  • Top Axis Value … Toggle on and provide the top value on the axis (unless a data point is greater).
  • Bottom Axis Value … Toggle on and provide the bottom value on the axis.
  • Axis “Zero” Value … This will reset the bottom axis value
  • Orientation … Horizontal or vertical
  • Show Legend … Hidden by default
  • Legend Position …Top, right or bottom
  • Size Mode … Auto, or Custom (provide Width and Height in pixels; and left, right, top and bottom margins)
  • Tick Count … Specify the number of tick marks (the interval is affected by the top axis value).
  • Custom Tick Labels … Display or hide the tick labels (and customize the text).
  • Title
  • Show Grid Lines … Off by default.
  • Show Values … Off by default.
  • Show Empty Bars … Off by default.
  • Format Values as Time … Off by default.
  • Starting Color … If there is more than one bar, subsequent bars will follow the color chart.
  • Conditional Formatting is available. These rules will override the automatic series coloring (based on series label).

Line Chart

  • Series Field … Select what categories the bars will represent.
  • X-Axis Type … Set to Date (line charts typically reference time on this axis). Note: Using Scores as a data source may not logically make sense with a line chart, since they function as a single value that may get updated.
  • X-Axis Field … Select the field to populate the X-axis.
  • Value Field … Select the value represented by the height of the bars (Y-Axis).
  • Value Summary Function … Average, Sum, Count, Min, Max
  • Value Label … Toggle on and provide a label
  • Top Axis Value … Toggle on and provide the top value on the axis (unless a data point is greater).
  • Bottom Axis Value … Toggle on and provide the bottom value on the axis.
  • Tick Count … Specify the number of tick marks (the interval is affected by the top axis value).
  • Custom Tick Labels … Display or hide the tick labels (and customize the text).
  • Title … Toggle on and provide a label.
  • Sub-Title … Toggle on and provide a label.
  • Show Grid Lines … Off by default.
  • Show Tooltips
  • Show Legend … Toggle on and choose position of legend.
  • Legend position … Right or Bottom.
  • Format Values as Time
  • Starting Color … If there is more than one line, subsequent lines will follow the color chart.
  • Conditional formatting is available. These rules will override the automatic series coloring (based on series label).

Pie Chart

  • Series Field … Select what categories the bars will represent.
  • Value Field … Select the value represented by the size of the pie sections.
  • Value Summary Function … Average, Sum, Count, Min, Max
  • Title … Toggle on and provide a label.
  • Sub-Title … Toggle on and provide a label.
  • Chart Size … Small, Medium or Large.
  • Pie Inner Radius … Enter a number in pixels; 0 by default. Increasing from 0 turns the pie into a donut.
  • Value Format … Percentages or Values.
  • Tooltip Format … Percentage, Value or Both.
  • Starting Color … If there is more than one slice, subsequent slices will follow the color chart.
  • Conditional formatting is available. These rules will override the automatic series coloring (based on series label).

Word Cloud

  • Word Field … You can select any field, but Comment typically makes the most sense.
  • Enter words to exclude … Write words, one on each line, to exclude them from the cloud.
  • Show Top N Words … This option will only display the specified number of top ranked words.
  • Minimum Word Count … This option will exclude words that don’t meet the minimum count threshold.
  • Minimum Word Length … This option will exclude words that don’t meet the minimum length threshold.

 

= = = = =

Version(s): GideonSoft 2021 Release 1 and later

 

Table of Contents