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.
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 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.
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.
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.
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
