"GChart" package contains ARI Smart Content - GChart module to create a responsive charts using Google Charts API using data from Database data data sources.
Data source which will be used by the extension should contain data in the following format (the sample table contains some expenses by different persons):
|
food
|
auto
|
hobbies
|
Mary
|
190
|
160
|
120
|
Tom
|
3
|
40
|
45
|
Brad
|
10
|
180
|
85
|
Kate
|
40
|
80
|
25
|
The following graph types will use data from this table like described below:
- Area chart will show several graphics (one graphic for each person) where each expense (marked with ■ color) will be used as label on X axis and values (marked with ■ color) will be used on Y axis.
- Bar chart will contains several groups (one group for each expense marked with ■ color) and each group will contains several bars (one bar for each person marked with ■ color). Values will be used (marked with ■ color) to detect bar length.
- Column chart will contains several groups (one group for each expense marked with ■ color) and each several bars (one bar for each person marked with ■ color). Values will be used (marked with ■ color) on Y axis.
- Line chart will show several graphics (one graphic for each person) where each expense (marked with ■ color) will be used as label on X axis and values (marked with ■ color) will be used on Y axis.
- Pie chart will contains several pieces (one piece for each person marked with ■ color). Value of each piece will be sum of all expenses by a person (for example for Mary it is 190 + 160 +120 = 470, for Tom it is 3 + 40 + 45 = 88 and etc).
