Widgets Guide

Pie Chart

Feature:

Create chart with aggregation type:
1.Count- Create pie chart for count of items, select column (numeric or non-numeric) and sort by Metric Count, Custom Metric or String.
2.Sum/Unique Count/Average/Min/Max- Create pie chart with the above aggregation type, select an aggregation column (numeric data) and a column to sort data. Sort chart by Metric Count, Custom Metric or String.

Sorting by Custom Metric enables user options for another aggregation field having Count, Sum, Average, Unique Count, Min & Max. Except Count other aggregation type provide options for another field to sort data by column.

Sub-Feature:

1. Order- Sort data in ascending or descending order
2. Count- Select count of data to be displayed
3. Enable search permission
4. Select local string format (None, UK/US English, Others)
5. Select decimal places (Round off, Two places, Three places)
6. Filter by- Option to filter out data as per requirements
(Format to filter data- Column name:”Item name” example if column name is Region and entity required is west format would be Region:”West”)
7. Apply date range filter (Refer next sheet for keywords of date range)
8. Apply numeric range filter.

Property:

1. Theme- Select from the various themes
2. Title- Enter title, option to select title position, title colour, title font and size. Same features available for subtitle.
3. Widget font size- Change widget font size
4. Grid- Change horizontal and vertical grid
5. Legend- Select legend icon and position. Options to hide or show legend, data legend, data in percent and scrollable legend.
6. Tooltip- Hide or show tooltip
7. Affixes- Select prefix or suffix for the displaying in data/ chart
8. Miscellaneous- Change radius, select chart style, select label position and chart animation type
9. Social collaboration- Show or hide social collaboration.

Doughnut Chart

Feature:

Create chart with aggregation type:
1. Count- Create chart for count of items, select column (numeric or non-numeric) and sort by Metric Count, Custom Metric or String.
2. Sum/Unique Count/Average/Min/Max- Create pie chart with the above aggregation type, select an aggregation column (numeric data) and a column to sort data. Sort chart by Metric Count, Custom Metric or String.

Sub Feature:

Property:

Theme- Select from the various themes
2. Title- Enter title, option to select title position, title colour, title font and size. Same features available for subtitle.
3. Widget font size- Change widget font size
4. Grid- Change horizontal and vertical grid
5. Legend- Select legend icon and position. Options to hide or show legend, data legend, data in percent and scrollable legend.
6. Tooltip- Hide or show tooltip
7. Affixes- Select prefix or suffix for the displaying in data/ chart
8. Miscellaneous- Change radius, select chart style, select label position and chart animation type and options to change outer and inner radius of doughnut chart.
9. Social collaboration- Show or hide social collaboration

Advanced Pie Chart

Feature:

Create chart with aggregation type:

1.Count- Create chart for count of items, select column (numeric or non-numeric) and sort by Metric Count, Custom Metric or String.

2.Sum/Unique Count/Average/Min/Max- Create chart with the above aggregation type, select an aggregation column (numeric data) and a column to sort data. Sort chart by Metric Count, Custom Metric or String.

Perform What if analysis- Combine or separate the items as per requirements
For example: Chart of quantity sold region wise, combine two or more regions or separate a region entirely as per requirement.

Sub- Feature:

1. Order- Sort data in ascending or descending order

2. Count- Select count of data to be displayed

3. Enable search permission

4. Select local string format (None, UK/US English, Others)

5. Select decimal places (Round off, Two places, Three places)

6. Filter by- Option to filter out data as per requirements

(Format to filter data- Column name:”Item name” example if column name is Region and entity required is west format would be Region:”West”)

7. Apply date range filter (Refer next sheet for keywords of date range)

8. Apply numeric range filter

Property:

1. Theme- Select from the various themes

2. Title- Enter title, option to select title position, title colour, title font and size. Same features available for subtitle.

4. Grid- Change horizontal and vertical grid

5. Legend- Select legend icon and position. Options to hide or show legend, data legend, data in percent and scrollable legend.

7. Affixes- Select prefix or suffix for the displaying in data/ chart

8. Miscellaneous- Change radius, select chart style, select label position and chart animation type

Advanced Doughnut Chart

Feature:

Create chart with aggregation type:

1.Count- Create chart for count of items, select column (numeric or non-numeric) and sort by Metric Count, Custom Metric or String.

Perform What if analysis like advanced Pie chart.

Sub- Feature:

1. Order- Sort data in ascending or descending order

2. Count- Select count of data to be displayed

3. Enable search permission

4. Select local string format (None, UK/US English, Others)

5. Select decimal places (Round off, Two places, Three places)

6. Filter by- Option to filter out data as per requirements

(Format to filter data- Column name:”Item name” example if column name is Region and entity required is west format would be Region:”West”)

7. Apply date range filter (Refer next sheet for keywords of date range)

8. Apply numeric range filter

Property:

1. Theme- Select from the various themes

2. Title- Enter title, option to select title position, title colour, title font and size. Same features available for subtitle.

4. Grid- Change horizontal and vertical grid

5. Legend- Select legend icon and position. Options to hide or show legend, data legend, data in percent and scroll-able legend.

7. Affixes- Select prefix or suffix for the displaying in data/ chart

8. Miscellaneous- Change radius, select chart style, select label position and chart animation type. Change inner and outer radius.

Basic Line Chart

Feature:

Create chart by selecting aggregation type, Y-axis aggregation column and X-axis column.

Create chart with aggregation type:

1. Count- Create chart for count of items, select column (numeric or non-numeric) and sort by Metric Count, Custom Metric or String.

2. Sum/Unique Count/Average/Min/Max- Create chart with the above aggregation type, select an aggregation column (numeric data) and a column to sort data. Sort chart by Metric Count, Custom Metric or String.

Sub- Feature:

1. Order- Sort data in ascending or descending order

2. Count- Select count of data to be displayed

3. Enable search permission

4. Select local string format (None, UK/US English, Others)

5. Select decimal places (Round off, Two places, Three places)

6. Filter by- Option to filter out data as per requirements

(Format to filter data- Column name:”Item name” example if column name is Region and entity required is west format would be Region:”West”)

7. Apply date range filter (Refer next sheet for keywords of date range)

8. Apply numeric range filter

Property:

1. Theme- Select from the various themes

2. Title- Enter title, option to select title position, title colour, title font and size. Same features available for subtitle.

4. Grid- Change horizontal and vertical grid

5. Legend- Select legend icon and position. Options to hide or show legend, data legend, data in percent and scrollable legend.

7. Affixes- Select prefix or suffix for the displaying in data/ chart

8. Miscellaneous- Change radius, select chart style, select label position, chart animation type, show or hide smooth line, show Markline and Mark Point of average, min or max. Change colours of line and point.
Select line style (Solid, Dashed, Dotted)
Select symbol style (Circle, Rectangle, Round rectangle, Diamond, Pin, Triangle)
Select symbol size.

10. X Axis- Show or hide x-axis, splitline, axisline. Change label position. Input custom x-axis name and change custom x-axis position. Same features for Y-axis.

Stacked Line Chart

Feature:

Create chart by selecting X-axis column and multiple columns for y-axis (aggregation and y-axis column)
Create chart with aggregation type:

1. Count- Create chart for count of items, select column (numeric or non-numeric) and sort by Metric Count, Custom Metric or String.

2. Sum/Unique Count/Average/Min/Max- Create chart with the above aggregation type, select an aggregation column (numeric data) and a column to sort data. Sort chart by Metric Count, Custom Metric or String.

Sub- Feature:

1. Order- Sort data in ascending or descending order

2. Count- Select count of data to be displayed

3. Enable search permission

4. Select local string format (None, UK/US English, Others)

5. Select decimal places (Round off, Two places, Three places)

6. Filter by- Option to filter out data as per requirements

(Format to filter data- Column name:”Item name” example if column name is Region and entity required is west format would be Region:”West”)

7. Apply date range filter (Refer next sheet for keywords of date range)

8. Apply numeric range filter

Property:

1. Theme- Select from the various themes

2. Title- Enter title, option to select title position, title colour, title font and size. Same features available for subtitle.

4. Grid- Change horizontal and vertical grid

5. Legend- Select legend icon and position. Options to hide or show legend, data legend, data in percent and scrollable legend.

7. Affixes- Select prefix or suffix for the displaying in data/ chart

8. Miscellaneous- Change radius, select chart style, select label position and chart animation type. Show or hide smooth line, Show Markline and Mark Point of average, min or max. Change colours of line and point.
Select line style (Solid, Dashed, Dotted). Select symbol style (Circle, Rectangle, Round rectangle, Diamond, Pin, Triangle). Select symbol size. Select line property and make changes for each line.

10. X Axis- Show or hide x-axis, splitline, axisline. Change label position. Input custom x-axis name and change custom x-axis position. Same features for Y-axis.

Vertical Stacked By Dimension

Feature:

Create chart with aggregation type, aggregation column, X-axis column and column to split bar type (to split the line).
Exampe: Creating a chart of sum (aggregation type) of quantity (aggregation column) region wise (X-axis column) for each product (Split bar type).
Aggregation parameters and sorting options same as pie chart.

Create chart with aggregation type:

1.Count- Create chart for count of items, select column (numeric or non-numeric) and sort by Metric Count, Custom Metric or String.

Sub- Feature:

1. Order- Sort data in ascending or descending order

2. Count- Select count of data to be displayed

3. Enable search permission

4. Select local string format (None, UK/US English, Others)

5. Select decimal places (Round off, Two places, Three places)

6. Filter by- Option to filter out data as per requirements

(Format to filter data- Column name:”Item name” example if column name is Region and entity required is west format would be Region:”West”)

7. Apply date range filter (Refer next sheet for keywords of date range)

8. Apply numeric range filter

Property:

1. Theme- Select from the various themes

2. Title- Enter title, option to select title position, title colour, title font and size. Same features available for subtitle.

4. Grid- Change horizontal and vertical grid

5. Legend- Select legend icon and position. Options to hide or show legend, data legend, data in percent and scrollable legend.

7. Affixes- Select prefix or suffix for the displaying in data/ chart

8. Miscellaneous- Display sum and its position.