Set Chart Properties

Objective

Complex Charts

The following charts are covered in this document:

 • Bubble
 • Bullet
 • Baseline
 • Circos
 • Complex Gauge
 • Heatmap
 • Map
 • Radar
 • Sankey
 • Sunburst
 • Tag cloud
 • Topology
 • Treemap

Custom Data Definitions for specific use cases

The following table shows the sample use case descriptions and saved custom data definitions for different chart types:

Chart	Sample use case	Sample Custom Data Definition
Bubble	To view the units sold and profit percent for items belonging to various categories in a supermarket.	SELECT CATEGORY,SALE_COUNT,PROFIT_PERCENT FROM "CHARTS"."BUBBLE"
Bullet	To compare the yearly predefined sales targets with the actual sales achieved for the following products in a supermarket: • Electronics • Groceries • Home Appliances • Fashion and Accessories	select 'Groceries' as CategoryName, 689000 as TotalUnitsSales, 600000 as Target from dual union select 'Home Appliances' as CategoryName, 450000 as TotalUnitsSales, 550000 as Target from dual union select 'Fashion and Accessories' as CategoryName, 537000 as TotalUnitsSales, 500000 as Target from dual union select 'Electronics' as CategoryName, 9000 as TotalUnitsSales, 30000 as Target from dual
Baseline	To compare the credit card application processing time with its baseline.	select * from "charts"."baseline_ibm" order by tstamp
Circos	To show the to-and-fro transfer of funds between the following countries, cities, and islands: • Brazil • Cayman Island • London • Nigeria •Sacramento • Singapore • Spain • Switzerland • UAE • Washington	SELECT SOURCE,DESTINATION,DATA_IN_DOLLER FROM "CHARTS"."CIRCOS"
Complex Gauge	To show temperature and pressure for a device.	Attached the following two data definitions to the chart: Query for Inner Gauge: select 87 as temperature from dual Query for Outer Gauge: select 278 as pressure from dual
Heatmap	To view and compare the maximum temperatures recorded across four years for the following places in Maharashtra, India: • Pune • Mumbai • Nashik • Mahabaleshwar	SELECT LOCATION,YEAR1,HEAT FROM "CHARTS"."HEATMAP"
Map	To view the distribution and performance of various cloud platforms and data centers that are located across various countries and cities.	SELECT "LAT","LANG","NAME","IDENTITY","PARENTID","MAPID","KPI1","KPI2","KPI3","KPI4","KPI5","CSSR","HOSR" FROM "CIO"."GIS_MAP"
Radar	To compare the allocated budget with the actual amount utilized by the following departments of an organization: Sales Marketing Development Customer Support Information technology Administration	SELECT ORGANIZATION,ALLOCATED_BUDGET,ACTUAL_SPENDING FROM "CHARTS"."RADAR"
Sankey	To show dollars transferred from Canada and USA to the following countries against some trade: Italy France Germany Spain	SELECT SOURCE,DESTINATION,TRADE_IN_MILLION_DOLLAR FROM "CHARTS"."SANKEY"
Sunburst	To view the distribution of resources across two locations in an organization.	select 1 as id, 0 as parent,77 as value, 'Root' as label from dual union select 2 as id, 1 as parent,52 as value, 'London' as name from dual union select 3 as id, 1 as parent,25 as value, 'New York' as name from dual union select 4 as id, 2 as parent,12 as value, 'Accounting' as name from dual union select 5 as id, 2 as parent,26 as value, 'Sales' as name from dual union select 6 as id, 2 as parent,36 as value, Setting Chart Properties 8 'Management' as name from dual union select 7 as id, 5 as parent,45 as value, 'Analysts' as name from dual union select 8 as id, 5 as parent,32 as value, 'Executives' as name from dual union select 9 as id, 3 as parent,10 as value, 'Technical' as name from dual union select 10 as id, 3 as parent,24 as value, 'HR' as name from dual union select 11 as id, 9 as parent,32 as value, 'Team Leaders' as name from dual union select 12 as id, 9 as parent,21 as value, 'Architects' as name from dual union select 13 as id, 9 as parent,10 as value, 'Developers' as name from dual union select 14 as id, 9 as parent,12 as value, 'Testers' as name from dual
Tag Cloud	To view the word cloud created for a list of terms. The word size is proportional to its value.	SELECT X,VALUE FROM "CHARTS"."TAG_CLOUD"
Topology	To view the location and managers for the following departments of an organization: Human Resource (HR) Administration Finance	SELECT node_name,group_name,source_node,dest_node,val FROM "acp"."{tablename}"
Treemap	To view the distribution of a product model across the following entities: Countries Cities Shops	SELECT id,parent,name,value,seqno FROM "charts"."TREEMAP";

Bubble Chart

The following images show the mapping of custom data definition with the chart properties:

Mapping Custom Data Definition in SERIES tab

Set Properties window – X-AXIS tab

Set Properties window – Y-AXIS tab

Set Properties window – LEGENDS tab

Set Properties window – COLORS tab

Bubble Chart preview

The following chart preview displays the units sold and profit percent for items belonging to various categories in a supermarket:

Bullet Chart

The following images show the mapping of custom data definition with the chart properties:

Mapping Custom Data Definition in SERIES tab

Note: The default tooltips are provided in the chart. However, you can change them if required.

Set Properties window - COLORS tab

Bullet Chart preview

The following Bullet chart preview displays the yearly predefined sales targets and the actual sales achieved for products in a supermarket:

Baseline Chart

The following images show the mapping of custom data definition with the chart properties:

Mapping Custom Data Definition in SERIES tab

Baseline Value field is optional. If you want a line graph to be plotted to show the baseline reference values, then you must enter a column name in the Baseline Value field. The High Value and Low Value data is used to plot the background range area.

Set Properties window - COLORS tab

Baseline Chart – Preview

The following Baseline Chart preview displays the actual credit card processing time as against the baseline that is displayed in blue. The Red Bars are displayed where the processing time is more than the desirable time.

Circos Chart

The following images show the mapping of custom data definition with the chart properties:

Mapping Custom Data Definition in SERIES tab

Set Properties window - COLORS tab

Circos Chart preview

The following chart preview displays the funds transferred between various countries, cities, and islands:

Custom Data Definition preview

The following image shows the custom data definition preview displaying all the data rows. The data in the source column is sorted in an ascending order for better data visualization:

Complex Gauge Chart

You need to add two data definitions for this chart, one for the inner gauge and the other for the outer gauge. The following screen captures show the custom data definition preview for both the data definitions and their mapping with the chart properties:

Set Properties window - CHART tab

Set Properties window - COLORS tab

Complex Gauge Chart preview

The following chart preview displays the temperature and pressure for a device:

Heatmap Chart

Mapping Custom Data Definition in SERIES tab

The following images show the mapping of custom data definition with the chart properties:

Set Properties window - ROWS tab

Set Properties window - COLUMNS tab

Set Properties window - COLORS tab

Custom Data Definition preview

The following image shows the custom data definition preview displaying all the data rows. The data in the heat column is sorted in an ascending order for better data visualization:

 

Heatmap Chart preview

The following chart preview displays the maximum temperatures recorded for certain places in Maharashtra across four years:

Map Chart

The following images show the mapping of custom data definition with the chart properties:

Custom Data Definition preview

The following screen capture shows the custom data definition preview. The column names that are highlighted in the preview are entered in the SERIES tab.

Set Properties window - SERIES tab

Map the data definition columns with the SERIES tab fields, as highlighted in the above image.

Set Properties window - CHART tab

Set Properties window - COLORS tab

Map Chart preview

Nested maps are created based on the data that is provided in the ID, Parent, and Map fields. The GIS MAP preview contains three drill-down charts. The following chart preview is the parent chart that displays the distribution and performance of various cloud platforms and data centers that are located across various countries and continents:

After you click any country, a drill-down map displaying the distribution and performance of various cloud platforms and data centers that are located across the country is displayed.

For example, after you click North America, a nested chart is displayed. This chart displays the distribution and performance of various cloud platforms and data centers that are located across North America:

After you click any city, a drill-down dashboard that shows various performance parameters for the data center located in that city is displayed:

For example, after you click Santa Clara, a drill-down dashboard that shows various performance parameters for the Santa Clara data center is displayed:

This is a separate drill-down dashboard that is attached to the Map chart.

Custom Data Definition preview

The following image shows the custom data definition preview displaying all the data rows. The data in the Name column is sorted in an ascending order for better data visualization:

Radar Chart

The following images show the mapping of custom data definition with the chart properties:

Custom Data Definition preview

The following screen capture shows the custom data definition preview:

Set Properties window - AXIS tab

Set Properties window - LEGENDS tab

Set Properties window - COLORS tab

Radar Chart preview

The following chart preview displays the actual amount utilized against the allotted amount for various departments within an organization:

The following images show the mapping of custom data definition with the chart properties:

Set Properties window - CHART tab

Set Properties window - COLORS tab

The following chart preview displays the dollars transferred from Canada to various countries. The width of the source and destination boxes and the connecting channels is proportion to the amount traded:

The following chart preview displays the dollars transferred from USA to various countries:

The following chart preview displays the dollars received by Germany from Canada and USA:

The following images show the mapping of custom data definition with the chart properties:

Set Properties window - CHART tab

Set Properties window - COLORS tab

The following image shows the custom data definition preview displaying all the data rows. The data in the id column is sorted in an ascending order for better data visualization:

The following chart preview displays the distribution of employees across London and New York:

Click London to view the employee distribution in London. The following preview is displayed:

Click New York to view the employee distribution in New York. The following preview is displayed:

The following images show the mapping of custom data definition with the chart properties:

Set Properties window - CHART tab

Set Properties window - COLORS tab

The following chart preview displays the word cloud. The word size is proportional to its value:

The following images show the mapping of custom data definition with the chart properties:

The following chart preview displays the location and managers for the HR, Administration, and Finance departments in ABC_Inc organization:

The following image shows the custom data definition preview displaying all the data rows. The data in the group_name column is sorted in an ascending order for better data visualization. The node_name and group_name columns are used to categorize the nodes and are not related to the other three columns of the table. Nodes with the same group name are displayed in a single color on the chart. The source_name and dest_node columns indicate the source nodes and destination nodes that are connected by edges.

The following images show the mapping of custom data definition with the chart properties:

Entering a data definition column name in the Size field is optional. However, if you enter a column name in the Size field, then that data is sorted based on the selection in the Sorting order list. If the Size field is blank, then the data of the Node value column is sorted based on the Sorting order list.

In the Chart depth list, enter or select the number of hierarchy levels to be displayed simultaneously on the chart. The default value is 1, where only the root and the first-level parent elements are displayed on the chart. In the list, enter or select the number of hidden hierarchy levels to be displayed as lines on the chart. These hidden hierarchy levels are the child and the sub child elements that are displayed on the chart. The default value is 0, where the hidden hierarchy levels are not displayed.

Set Properties window - COLORS tab

Nested treemaps are created based on the data that is provided in the ID, Parent, Chart depth, and Chart hint fields. The following chart preview is the root chart that displays the distribution of products across various countries.

After you click any country, a drill-down map displaying the distribution of products across various cities in that country is displayed.

After you click any city, a drill-down map displaying the distribution of products across various stores in that city is displayed.

After you click any store, a drill-down map displaying the model wise distribution of products across that store is displayed.

The following image shows the custom data definition preview displaying all the data rows. The data in the Name column is sorted in an ascending order for better data visualization.