Widgets Guide

Pie/Doughnut

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.

Line

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.

Step Chart

Feature:

Select Y-axis aggregation type, Y-axis column, 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

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

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

Graph on Cartesian Chart

Feature:

Select Y-axis aggregation type, Y-axis column, 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

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.

Bar

Vertical Bar Chart

Feature:

Select Y-axis 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- Show markline for min, max, average. Show mark point for min,max, average. Options available to change colour of line and point. Select position to display sum.

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

11. Same features for Y-axis plus feature to select y axis range min, max and interval (Since y axis is the aggregation field)

Above chart shows quantity sold region wise showing markline and markpoint for average quantity sold.

Horizontal Bar Chart

Feature:

Select X-axis aggregation type, X-axis aggregation column 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- Show markline for min, max, average. Show mark point for min,max, average. Options available to change colour of line and point. Select position to display sum.

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

11. Same features for Y-axis plus feature to select y axis range min, max and interval (Since y axis is the aggregation field).

Horizontal Stacked By Metrics

Feature:

Create chart by selecting Y-axis column.
Select X-Axis aggregation type, column and custom name for column. (Multiple columns can be added).

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- Select position to display sum, count etc.

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 Metrics

Feature:

Create chart by selecting X-axis column.
Select Y-Axis aggregation type, column and custom name for column. (Multiple columns can be added).

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- Select position to display sum, count etc.

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.

Horizontal Comparative

Feature:

Create chart by selecting Y-axis column.
Select X-Axis aggregation type, column and custom name for column. (Multiple columns can be added).

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- Select field for mark line, Show markline for min, max, average. Show mark point for min,max, average. Options available to change colour of line and point. Select position to display sum.

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 Comparative Chart

Feature:

Create chart by selecting X-axis column.
Select Y-Axis aggregation type, column and custom name for column. (Multiple columns can be added).

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

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.

Horizontal Stacked By Dimension

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.

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- Option to select position of sum. Show or hide stacked.

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 by selecting aggregation type, X-axis parameter and bar splitting parameter.

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- Option to select position of sum. Show or hide stacked.

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.

Variance Chart

Feature:

Create chart with aggregation type, aggregation column, X-axis column and Budget/ Forecast column.
Option available for showing reverse variance.

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- Show markline for min, max, average. Show mark point for min,max, average. Options available to change colour of line and point.

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 plus feature to select y axis range min, max and interval (Since y axis is the aggregation field).

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

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- Show markline for min, max, average. Show mark point for min,max, average. Options available to change colour of line and point.

Waterfall Chart

Feature:

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

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- Option to invert column and select position to display sum.

Heat Map

Feature:

Create chart by selecting aggregation type, aggregation column, X-axis column and split bar type.
Example: Heat Map Chart created for sum (aggregation type) of quantity (aggregation column) region wise (X-axis column) and city (split bar type)- chart of sum of quantity city wise in every region can be seen.

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

9. 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 plus feature to select y axis range min, max and interval (Since y axis is the aggregation field).

Vertical Bar By Fields

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.

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

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.

Area

Basic Area Chart

Feature:

Select Y-axis aggregation type, Y-axis column, X-axis column.

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.

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

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.

Large Scale Area Chart

Feature:

Select Y-axis aggregation type, Y-axis column, X-axis 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.

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

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 Area Chart

Feature:

Select X-axis column, Y-axis aggregation column and type (multiple columns can be added).

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- Select Line to make changes ans then select line style, symbol style, 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.

Vertical Stacked Area By Dimension

Feature:

Select Aggregation type, aggregation column, X-axis column and split bar type column.

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.

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- Select position for displaying Sum (Total) of the aggregation in chart.

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.

Polar

Polar Angle Chart

Feature:

Select aggregation type, aggregation column and angle axis.

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.

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

10. Angle axis- Show or hide angle axis, split line, axis line.

Polar Stacked Angle Chart

Feature:

Select aggregation column, under angle axis select aggregation type, axis column and give custom name to column (if required). Multiple types of aggregation and axis columns can be added.

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

10. Angle axis- Show or hide angle axis, split line, axis line.

Polar Comparative Angle Chart

Feature:

Create comparisons between various fields: Select aggregation column, under angle axis select aggregation type, axis column and custom name for column (various columns can be added).

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

10. Angle axis- Show or hide angle axis, split line, axis line.

Polar Radius Chart

Feature:

Select aggregation type, aggregation column and Radius axis.

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.

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

10. Radius axis- Show or hide angle axis, split line, axis line.

Polar Stacked Radius Chart

Feature:

Select aggregation column, under radius axis select aggregation type, axis column and give custom name to column (if required). Multiple types of aggregation and axis columns can be added.

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

10. Radius axis- Show or hide angle axis, split line, axis line.

Polar Comparative Radius

Feature:

Create comparisons between various fields: Select aggregation column, under radius axis select aggregation type, axis column and custom name for column (various columns can be added).

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

10. Radius axis- Show or hide angle axis, split line, axis line.

Funnel

Basic Funnel Chart

Feature:

Select aggregation type, aggregation column and column field.

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.

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- Select label position and shape.

Aggregated Funnel Chart

Feature:

Select aggregation type, aggregation column and custom column name (if required).

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.

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- Select label position and shape.

Metrics

Metric Chart

Feature:

Select aggregation type and aggregation 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.

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. Title- Enter title, option to select title position, title colour, title font and size. Same features available for subtitle.

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

3. Miscellaneous- Select background colour/ image. Colour- Change font to bold, italic, change colour, font size, font style, chart shape and font colour. Image- Select image, change opacity of image, change font style, font size, chart shape and font colour.

Descriptive Metric Chart

Feature:

Select aggregation type and aggregation column. (multiple fields can be added)

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.

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. Miscellaneous- Select background image/ colour
Color- Select bold font or italic, background color, font size, font style, text direction, font color and option to move text.
Image- Select image, change opacity, font size, font style, text direction, font color and option to move text.
In the option of phrase- enter text to be displayed on chart.

Advanced Descriptive Metric

Feature:

Select aggregation type and aggregation column. (multiple fields can be added)

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.

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. Table- Change table allignment, add borders

2. Miscellaneous- Change background color

In the chart area: (image below)
First, select columns to make changes
Apply conditions: Select condition, field value, use image, change image allignment, image size and text colour.
Varied options for custom images available in 'custom images'.

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

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

10. Gauge Axis- Set min, max, angle, pointer size, show or hide splitline.

Data Table

Features:

Select aggregation type, aggregation column, custom column name, and column field.

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. Title- Enter title, option to select title position, title colour, title font and size. Same features available for subtitle.

3. Table- Apply borders, apply zebra rows, column orientation, record per page, header color and text color.

4. Miscellaneous- Show or hide pagination and total.

In the chart area:
First, select columns to make changes
Style- Change font style, font size, text type, select options for bold and italic.
Apply conditions: Select condition, field value, use image, change image allignment, image size and text colour.
Link- Enter hyperlink.
Custom image- Varied options for custom images available.
Add prefix or suffix as required.

Discovery Table

Create Discovery Table from Data discover option.

Select the created discovery table from the list.

Pivot Discovery Table

Feature:

Select dimension, select aggregation type and aggregation field and custom column name.

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. Title- Enter title, option to select title position, title colour, title font and size. Same features available for subtitle.

3. Table- Apply borders, apply zebra rows, column orientation, record per page, header color and text color.

4. Miscellaneous- Show or hide pagination and total.

In the chart area:
First, select columns to make changes
Style- Change font style, font size, text type, select options for bold and italic.
Apply conditions: Select condition, field value, use image, change image alignment, image size and text colour.
Link- Enter hyperlink.
Custom image- Varied options for custom images available.
Add prefix or suffix as required.

Multimetric Pivot Discovery

Feature:

Select Metric column Type of aggregation, column of aggregation and custom column name.

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. Title- Enter title, option to select title position, title colour, title font and size. Same features available for subtitle.

3. Table- Apply borders, apply zebra rows, column orientation, record per page, header color and text color.

4. Miscellaneous- Show or hide pagination and total.

In the chart area:
First, select columns to make changes
Style- Change font style, font size, text type, select options for bold and italic.
Apply conditions: Select condition, field value, use image, change image alignment, image size and text colour.
Link- Enter hyperlink.
Custom image- Varied options for custom images available.
Add prefix or suffix as required.

Multimetric Stacked Table

Feature:

Under metric column: Select aggregation type, aggregation column and custom name.
Under Dimension column: Selection dimension column, custom column name and size.
Multiple metrics and dimensions can be added.
Aggregation type same as 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. Title- Enter title, option to select title position, title colour, title font and size. Same features available for subtitle.

3. Table- Apply borders, apply zebra rows, column orientation, record per page, header color and text color.

4. Miscellaneous- Show or hide pagination and total.

Table- Sorting options available
Miscellaneous- Show or hide row and column totals, enter custom name, change font color and background colour.
In the chart area:
1. Options for changes in table available: Adding sum, integer sum, average, median etc (as shown in pic in column G)
2. Options available for interchanging row and column positions (as shown in pic in column H)
3. Add column properties, row propeties, sorting options.

Advanced Pivot Discovery

Feature:

Select aggregation type and aggregation column.
Select column and column size.

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. Title- Enter title, option to select title position, title colour, title font and size. Same features available for subtitle.

3. Table- Apply borders, apply zebra rows, column orientation, record per page, header color and text color.

4. Miscellaneous- Show or hide pagination and total.

In the chart area:

First, select columns to make changes
Style- Change font style, font size, text type, select options for bold and italic.
Apply conditions: Select condition, field value, use image, change image allignment, image size and text colour.
Link- Enter hyperlink.
Custom image- Varied options for custom images available.
Add prefix or suffix as required.

Table- Sorting options available
Miscellaneous- Show or hide row and column totals, enter custom name, change font color and background colour.
In the chart area:
1. Options available for interchanging row and column positions (as shown in pic in column G)
2. Add column properties, row properties, sorting options.

Bizdata Frame

Feature:

Select columns for reporting.
Select column size.

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. Title- Enter title, option to select title position, title colour, title font and size. Same features available for subtitle.

In the chart area: (Image attached below)

Option available to configure.

Configure settings has the following features available:

Group by- Columns placed under group by will enable dataset to be grouped by that particular field used.
Split by- Columns placed under split by will enable dataset to be split by the field selected.
Order- Columns placed under order will enable to order dataset through the available options i.e increasing or decreasing.
Where- Columns placed under where will enable filtering of the data with the options available in the column used. (For example is column is region and has information East, West, North, South users can filter data according to South, North, East or West.)
The default view of data in Bizdata frame is datagrid. Users can change it to other forms of reporting through the options available in Bizdata Frame. Options available are- Treemap, Sunburst, Xmap, Heatmap, x/Y Line, X/Y Scatter, Y Bar, Y Line, Y Area, Y Scatter, OHLC and Candlestick. Fileds can be selected, deleted and changed for using the various forms of reporting mentioned and to generate the desired results.
Feature to add new column in the existing table.
Theme can be changed. Available themes are- Pro light, Pro dark, Monokai, Solarized, Solarized Dark and Vaporwave.
Option to align scroll and free scroll.
Reset option to reset data to the the existing format removing all alterations done by grouping, splitting, order and filters.
Data can be exported to various formats- csv, JSON, arrow, html
Data can be copied to csv or JSON format.
Users can change style of data within columns. Features to round off decimal, change style such as Bar, gradient and change colour.

Screenshot from 2023-06-16 14-02-07.png

Bizdata Frame Expressions

To assign value of old header to new header

Here new_header_name is the name of the new column

// new_header_name

var new_header_name:="old_header_name"

Here Daily Gross Sales is the name of the new column

// Daily Gross Sales

var Daily_Gross_Sales:"old column name"

Arithmetic & Assignment Operators

Here x and y are columns in the data grid table.
Generate a dimension to store the calculated fields.
// new_dimension

OPERATOR	DEFINITION
+	Addition between x and y. (eg: x + y)
-	Subtraction between x and y. (eg: x - y)
*	Multiplication between x and y. (eg: x * y)
/	Division between x and y. (eg: x / y)
%	Modulus of x with respect to y. (eg: x % y)
^	x to the power of y. (eg: x ^ y)
:=	Assign the value of x to y. Where y is either a variable or vector type. (eg: y := x)
+=	Increment x by the value of the expression on the right hand side. Where x is either a variable or vector type. (eg: x += abs(y - z))
-=	Decrement x by the value of the expression on the right hand side. Where x is either a variable or vector type. (eg: x[i] -= abs(y + z))
*=	Assign the multiplication of x by the value of the expression on the righthand side to x. Where x is either a variable or vector type. (eg: x *= abs(y / z))
/=	Assign the division of x by the value of the expression on the right-hand side to x. Where x is either a variable or vector type. (eg: x[i + j] /= abs(y * z))
%=	Assign x modulo the value of the expression on the right hand side to x. Where x is either a variable or vector type. (eg: x[2] %= y ^ 2)

Equalities & Inequalities

Here x and y are columns in the data grid table.
Generate a dimension to store the calculated fields.
// new_dimension

OPERATOR	DEFINITION
== or =	True only if x is strictly equal to y. (eg: x == y)
<> or !=	True only if x does not equal y. (eg: x <> y or x != y)
<	True only if x is less than y. (eg: x < y)
<=	True only if x is less than or equal to y. (eg: x <= y)
>	True only if x is greater than y. (eg: x > y)
>=	True only if x greater than or equal to y. (eg: x >= y)

General Purpose Functions

Here x and y are columns in the data grid table.
Generate a dimension to store the calculated fields.
// new_dimension

FUNCTION	DEFINITION
abs	Absolute value of x. (eg: abs(x))
avg	Average of all the inputs. (eg: avg(x,y,z,w,u,v) == (x + y + z + w + u + v) / 6)
ceil	Smallest integer that is greater than or equal to x.
clamp	Clamp x in range between r0 and r1, where r0 < r1. (eg: clamp(r0,x,r1))
equal	Equality test between x and y using normalised epsilon
erf	Error function of x. (eg: erf(x))
erfc	Complimentary error function of x. (eg: erfc(x))
exp	e to the power of x. (eg: exp(x))
expm1	e to the power of x minus 1, where x is very small. (eg: expm1(x))
floor	Largest integer that is less than or equal to x. (eg: floor(x))
frac	Fractional portion of x. (eg: frac(x))
hypot	Hypotenuse of x and y (eg: hypot(x,y) = sqrt(xx + yy))
iclamp	Inverse-clamp x outside of the range r0 and r1. Where r0 < r1. If x is within the range it will snap to the closest bound. (eg: iclamp(r0,x,r1)
inrange	In-range returns 'true' when x is within the range r0 and r1. Where r0 < r1. (eg: inrange(r0,x,r1)
log	Natural logarithm of x. (eg: log(x))
log10	Base 10 logarithm of x. (eg: log10(x))
log1p	Natural logarithm of 1 + x, where x is very small. (eg: log1p(x))
log2	Base 2 logarithm of x. (eg: log2(x))
logn	Base N logarithm of x. where n is a positive integer. (eg: logn(x,8))
max	Largest value of all the inputs. (eg: max(x,y,z,w,u,v))
min	Smallest value of all the inputs. (eg: min(x,y,z,w,u))
mul	Product of all the inputs. (eg: mul(x,y,z,w,u,v,t) == (x * y * z * w * u * v * t))
ncdf	Normal cumulative distribution function. (eg: ncdf(x))
not_equal	Not-equal test between x and y using normalised epsilon
pow	x to the power of y. (eg: pow(x,y) == x ^ y)
root	Nth-Root of x. where n is a positive integer. (eg: root(x,3) == x^(1/3))
round	Round x to the nearest integer. (eg: round(x))
roundn	Round x to n decimal places (eg: roundn(x,3)) where n > 0 and is an integer. (eg: roundn(1.2345678,4) == 1.2346)
sgn	Sign of x, -1 where x < 0, +1 where x > 0, else zero. (eg: sgn(x))
sqrt	Square root of x, where x >= 0. (eg: sqrt(x))
sum	Sum of all the inputs. (eg: sum(x,y,z,w,u,v,t) == (x + y + z + w + u + v + t))
swap <=>	Swap the values of the variables x and y and return the current value of y. (eg: swap(x,y) or x <=> y)
trunc	Integer portion of x. (eg: trunc(x))

Worksheet

Two options available: Create Data source and Add Data source

Create Data source: Through worksheet widget, data source can be created. Once created data source can be added through 'Select data source option' and used for reporting.

After adding data source, users can create columns and define datatype (Text/String, Boolean, Integer/Float, Long, Date, Keyword, Binary)
Primary keys can be defined by using column names. (Format- {column1}{column2})

2. Add existing data source-

Through 'Select Data Source' option, data source cab be added for reporting. After adding data source, specific columns can be selected for reporting.

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. Title- Enter title, option to select title position, title colour, title font and size. Same features available for subtitle.

3. Table- Count of record per page, header background color, text color.

Defining Primary Key:

Each entry in a table is uniquely identified by a column or collection of columns known as the primary key. It guarantees that the primary key column(s) for any two records in the table cannot have the same values.

Format for defining Primary Key:
1. For 1 Primary Key: {column name}
2. For combination of Primary Keys: {column name 1}{column name 2}.....

Primary key is defined in the below mentioned space:

Functioning of Worksheet Widget (Use Case)

Adding extra row- For adding extra rows to an already existing table, define Primary Keys first (can be a single or combination of primary keys).
Go to 'Browse' and select the required file (in CSV or JSON format)
Click 'Upload' to upload the file.
This will enable addition of extra rows in the designated places and addition of any duplicate record will be unsuccessful.
Adding extra column- For adding extra columns to an already existing table, define Primary Keys first (can be a single or combination of primary keys).
Go to 'Browse' and select the required file (in CSV or JSON format)
Click 'Upload' to upload the file.
This will enable addition of extra columns in the designated places and addition of any duplicate record will be unsuccessful.

Table Comparison

Feature:

Select multiple columns for comparison, select object and revision 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. Title- Enter title, option to select title position, title colour, title font and size. Same features available for subtitle.

2. Table- Apply border, apply zebra borders, header color, text color.

Bizdata Smart Table

Feature:

Select multiple columns (option to show or hide bar),
Select Line, Bar, Tristate micro charts,
Add data points (Multiple numeric data points can be added).

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. Title- Enter title, option to select title position, title colour, title font and size. Same features available for subtitle.

3. Table- Apply borders, apply zebra rows, column orientation, record per page, header color and text color.

4. Miscellaneous- Show or hide pagination and total.

In the chart area:
First, select columns to make changes
Style- Change font style, font size, text type, select options for bold and italic.
Apply conditions: Select condition, field value, use image, change image alignment, image size and text colour.
Link- Enter hyperlink.
Custom image- Varied options for custom images available.
Add prefix or suffix as required.

Table sorting options available.

Bizdata Pixel Report

Feature:

Select Dimension Column (multiple columns can be added)

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. Table- Select table alignment, table border

2. Miscellaneous- Change background color

Hierarchy Table

Feature:

Select aggregation type, aggregation column, select columns, select size of columns (multiple columns can be added).

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. Title- Enter title, option to select title position, title colour, title font and size. Same features available for subtitle.

2. Table- Apply border, apply zebra borders, header color, text color, sorting options available.

3. Miscellaneous- Show or hide row and column total.

Tree

Basic Tree Chart

Feature:

Select aggregation type, aggregation column and column field (multiple columns can be added)

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

Vertical Tree Chart

Features:

Select aggregation type, aggregation column and column field (multiple columns can be added)

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- Show or hide curve line, select tree depth, symbol style, symbol style, font style, font size, line color and label color.

Horizontal Tree Chart

Features:

Select aggregation type, aggregation column and column field (multiple columns can be added)

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- Show or hide curve line, select tree depth, symbol style, symbol style, font style, font size, line color and label color.

Sunburst Chart

Features:

Select aggregation type, aggregation column and column field (multiple columns can be added)

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- Select radius and label size.

Data Tree Chart

Features:

Select path, parent column and column field (multiple columns can be added).

Sub-Features:

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. Title- Enter title, option to select title position, title colour, title font and size. Same features available for subtitle.

2. Table- Apply border, apply zebra borders, header color, text color.

Network Chart

Feature:

Select category, parent column, child column, node column and optional fields such as relationship value, relationship value length, relationship value width, aggregation column, node size and level.

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. Title- Enter title, option to select title position, title colour, title font and size. Same features available for subtitle.
2. Social Collaboration- Show or hide.

Special

Radar Chart

Feature:

Select aggregation column, under radar points select aggregation type and aggregation column (multiple columns can be added).

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- Select radius size, symbol style and symbol size.

10. Radar Axis- Show or hide splitline, axisline, data and select data position.

Area Radar Chart

Feature:

Select aggregation column, under radar points select aggregation type and aggregation column (multiple columns can be added).

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- Select radius size, symbol style and symbol size.

10. Radar Axis- Show or hide splitline, axisline, data and select data position.

Word Cloud

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.

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

Basic Scatter Chart

Feature:

Select x-axis and y-axis 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.

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- Show markline for min, max, average. Show mark point for min,max, average. Options available to change colour of line and point.
Select position to display sum.

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.

Bubble Chart

Feature:

Select dimension column, select aggregation type and aggregation column of x-axis, y-axis and volume.

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- Select position to display sum/ count.

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.

Basic Map Chart

Feature:

Select aggregation type, aggregation column and location (Latitiude and Longitude).

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. Title- Enter title, option to select title position, title colour, title font and size. Same features available for subtitle.

4. Miscellaneous- Select background color, marker color and marker size

Advanced Map Chart

Feature:

Select aggregation type, aggregation column and location (Latitiude and Longitude).

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. Title- Enter title, option to select title position, title colour, title font and size. Same features available for subtitle.

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

3. Miscellaneous- Set range, set range min, max, marker type and marker color. Multiple column list can be added.

Advanced Integrated Map Chart

Feature:

Select aggregation type, aggregation column, location (Latitude and Longitude) and column field

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. Title- Enter title, option to select title position, title colour, title font and size. Same features available for subtitle.

2. Miscellaneous- Select chart type (Pie or Bar)

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

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- Select mark line and mark point.

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

In the chart area:
Options to change chart type (as shown in image below)
Show vertical, horizontal stacked, vertical stacked and line chart.