Difference between revisions of "Creating Charts and Dashboards - Overview"

From SmartWiki
Jump to: navigation, search
 
 
(4 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 +
{{SeqReportPageHeader}}
 +
 
You can associate charts with reports to provide the [[User|user]] with a visual representation of the data used in the report.  When converting a report into a chart you can:
 
You can associate charts with reports to provide the [[User|user]] with a visual representation of the data used in the report.  When converting a report into a chart you can:
 
* Create multiple charts of different types for the same report.
 
* Create multiple charts of different types for the same report.
Line 31: Line 33:
 
* '''Chart Name''' - Name for this chart.  By default this name is taken from the report name.
 
* '''Chart Name''' - Name for this chart.  By default this name is taken from the report name.
 
* '''Description''' - Narrative description of the chart.  By default this description is taken from the report description.
 
* '''Description''' - Narrative description of the chart.  By default this description is taken from the report description.
* '''Chart Type''' - Choose from Bar Chart, 3D Bar Chart, Pie Chart, 3D Pie Chart, Meter, Area, Line, and Table.
+
* '''Chart Type''' - Choose from a number of options, including Bar Chart, 3D Bar Chart, Pie Chart, 3D Pie Chart, Meter, Area, Line, and Table.
 
* '''Maximum value''' - For a Meter chart - only determines the maximum value displayed on the Meter.
 
* '''Maximum value''' - For a Meter chart - only determines the maximum value displayed on the Meter.
 
* '''Background Colour''' - Colour to be displayed behind the chart.
 
* '''Background Colour''' - Colour to be displayed behind the chart.
Line 84: Line 86:
 
[[Image:Reps103.png]]
 
[[Image:Reps103.png]]
 
   
 
   
 +
{{PrevNextStart}} [[Building Sub-Reports]]
 +
{{PrevNextMid}} [[Adding a Chart to the Pin Board]] {{PrevNextEnd}}
  
[[Category:Reports]][[Category:System Management]][[Category:Applications]]
+
[[Category:Reports]]

Latest revision as of 10:54, 9 December 2016

caption Click here to watch a video on SmartSimple's integrated reporting subsystem.

You can associate charts with reports to provide the user with a visual representation of the data used in the report. When converting a report into a chart you can:

  • Create multiple charts of different types for the same report.
  • Link multiple charts to the visual dashboard.
  • Link a chart to the pin board.
  • Embed a chart through a custom field to some other object. For example, a year-to-date sales chart can be lined to each sales person’s profile.

1. Review the Employees by Department report.

Reps86.png

2. Close the preview.

3. Edit the Report.

4. Click the Charts tab.

The list of charts is displayed – currently blank until you add some charts.

Reps85.png

You can add any number of charts of different types to a single report.

5. Click the New Chart tab.

The Chart Window is displayed.

Reps84.png

This page consists of the following settings:

  • Chart Name - Name for this chart. By default this name is taken from the report name.
  • Description - Narrative description of the chart. By default this description is taken from the report description.
  • Chart Type - Choose from a number of options, including Bar Chart, 3D Bar Chart, Pie Chart, 3D Pie Chart, Meter, Area, Line, and Table.
  • Maximum value - For a Meter chart - only determines the maximum value displayed on the Meter.
  • Background Colour - Colour to be displayed behind the chart.
  • Series Colour - Colours to be used for each series in the chart.
  • Series Label - The format of any labels required for the series.
  • Label Columns - The report columns to be used for the label column.
  • Series - The report columns to be used as the data series for the report.
  • X Axis Legend - Test legend for the horizontal X Axis.
  • Y Axis Legend - Test legend for the vertical Y Axis.
  • Chart URL - A generated URL that can be used to embed the chart in a custom field or on the clipboard.

6. Set the Chart Type to Pie Chart.

7. Set the Series Label to Both.

This will display a Series legend below the pie chart and the value of each pie segment next to the segment.

8. Set the Label Column to Department.

Each section of the pie chart will be labeled with the department name.

9. Set the Series to Last Name.

The numeric values in the Last name column will be used to specify the size of each pie segment.

10. Click the Save button.

The URL is added to the Chart URL box and the Preview button is now displayed.

11. Click the Preview button.

The Pie chart is displayed in a separate window.

Reps101.png

12. Close the Preview window.

13. Click the Chart List tab.

The new chart is displayed on the list.

14. Create an additional chart displayed as a Bar Chart.

Reps102.png

15. Close the Preview window.

16. Click the Chart List tab.

There are two charts on the list for the same report.

Reps103.png




Previous.png Building Sub-Reports Adding a Chart to the Pin Board Next.png