Charting data: Difference between revisions

From Memento Database Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
Line 14: Line 14:
Select the fields of the library whose values are to be used for building the chart.
Select the fields of the library whose values are to be used for building the chart.


Charts are built using Google Charts API and HTML5. Google Charts API requires an active connection to the Internet for downloading JavaScript functions for building charts.<br />
Charts requires an active connection to the Internet for building charts.
All code and data are processed and rendered in the browser. No data is sent to any server.
All code and data are processed and rendered in the browser. No data is sent to any server.


== Pie Chart ==
== Pie Chart ==
Data sources:
Build a pie chart with the following parameters:
* Category: Field, the values of which are sectors on a pie chart. When category is a field of date or date/time type, the values can be grouped by hour, date, month or year.
* Values: record number or numeric field that define sector size.
* Function: Defines sector size calculation method. The default function is Sum. Sector size equals the sum of all value fields of the category’s records.


Example: Tasks
; Category
* Objective: Show number of tasks by priority
: Field, the values of which are sectors on a pie chart. When category is a field of date or date/time type, the values can be grouped by hour, date, month or year.
* Category: Priority
* Values: Number of entries
[[Image:Pie.png]]


== Line Charts / Area Chart ==
; Values
Data sources:
: record number or numeric field that define sector size.
* Axis Х: Field of values to be placed on axis X.
 
* Axis Y: Field of values that define the point the chart line will go through.
; Function
* Function: Defines method for calculating the value on axis Y. The default method is Sum. The value on axis Y for X equals the sum of all Y-fields in the records with X-field equal to X.
: Defines sector size calculation method. The default function is Sum. Sector size equals the sum of all value fields of the category’s records.
* Series: Used for building charts with multiple lines. The value of this field defines the line a certain record belongs to.
 
; Example Tasks
: Objective: Show number of tasks by priority
:  Category: Priority
: Values: Number of entries
: [[Image:Pie.png]]
 
== Line Chart / Area Chart ==
Build a line our area chart with the following parameters:
 
; Axis Х
: Field of values to be placed on axis X
 
; Axis Y
: Field of values that define the point the chart line will go through
 
; Function
: Defines method for calculating the value on axis Y. The default method is Sum.<br/>The value on axis Y for X equals the sum of all Y-fields in the records with X-field equal to X.
 
; Series
: Used for building charts with multiple lines. The value of this field defines the line a certain record belongs to.


If the ''X-field'' is a number or date, you can specify axis type – ''discrete'' or ''continuous''.
If the ''X-field'' is a number or date, you can specify axis type – ''discrete'' or ''continuous''.
* ''Discrete'' axis contains only those X values that are present in the records.
 
* ''Continuous'' axis contains all values of type X in ascending order.
; ''Discrete'' axis
For example, if the type of a field X is numeric and the library contains records with values 1,4,7.
: contains only those X values that are present in the records.<br/>The discrete axis will appear as: 1,4,7.
* The discrete axis will appear as: 1,4,7
 
* The continuous axis will appear as: 1,2,3,4,5,6,7,8,9
; ''Continuous'' axis
: contains all values of type X in ascending order.<br/>For example, if the type of a field X is numeric and the library contains records with values 1,4,7.<br/>The continuous axis will appear as: 1,2,3,4,5,6,7,8,9.


Example: Purchases
Example: Purchases

Revision as of 17:08, 10 September 2016

« Page as of 2016-09-10, editions Mobile 3.9.7, Desktop 1.0.3 »

This page is incomplete and under development.

The Charts List screen primarily presents a list of defined charts and allows the user to view the chart of choice based on the library data.

You can visualize your data using different graphics. Memento supports the following types of graphics: Pie, Line, Bar, Columns, Area, Scatter, and Stepped Area.

How to build a chart

In the Library Entries List screen, a Right Side Menu may or may not be visible, depending on the platform and device. If it is not visible, pull it out by swiping from the right edge to the left. Select Charts.

Press the Add icon (+) and select the type of the chart you want to build; this opens the chart settings screen.

Select the fields of the library whose values are to be used for building the chart.

Charts requires an active connection to the Internet for building charts. All code and data are processed and rendered in the browser. No data is sent to any server.

Pie Chart

Build a pie chart with the following parameters:

Category
Field, the values of which are sectors on a pie chart. When category is a field of date or date/time type, the values can be grouped by hour, date, month or year.
Values
record number or numeric field that define sector size.
Function
Defines sector size calculation method. The default function is Sum. Sector size equals the sum of all value fields of the category’s records.
Example Tasks
Objective: Show number of tasks by priority
Category: Priority
Values: Number of entries
Pie.png

Line Chart / Area Chart

Build a line our area chart with the following parameters:

Axis Х
Field of values to be placed on axis X
Axis Y
Field of values that define the point the chart line will go through
Function
Defines method for calculating the value on axis Y. The default method is Sum.
The value on axis Y for X equals the sum of all Y-fields in the records with X-field equal to X.
Series
Used for building charts with multiple lines. The value of this field defines the line a certain record belongs to.

If the X-field is a number or date, you can specify axis type – discrete or continuous.

Discrete axis
contains only those X values that are present in the records.
The discrete axis will appear as: 1,4,7.
Continuous axis
contains all values of type X in ascending order.
For example, if the type of a field X is numeric and the library contains records with values 1,4,7.
The continuous axis will appear as: 1,2,3,4,5,6,7,8,9.

Example: Purchases

  • Objective: Show amounts of funds spent by day.
  • Axis Х: Purchase Date
  • Axis Y: Price

Purchases.png

Bar Chart / Column Char

Data sources:

  • Columns: Field the values of which are bars on the chart.
  • Values: Field the values of which define the size of the bar.
  • Series: Field for splitting records into individual data sets. Each data set will have its own bar for the respective value of the bar field.

Example:CD Collections

  • Objective: Show the number of disks bought each month grouped by genre.
  • Columns: Purchase Date, Group by month
  • Values: Number of entries
  • Series: Genre

Columns.png

Scatter Chart

A scatter chart is used to map correlation between sets of numbers. Each record of the library will be presented on the chart as a point.

Data sources:

  • Axis Х: Field for defining the coordinate of the point on axis X.
  • Axis Y: Field for defining the coordinate of the point on axis Y.

Scatter.png