Visualization Type

Ask Zia has the ability to create a wide variety of reports. As you type the question, Ask Zia will understand your intent, and reply with the best report type that suits your scenario. You can always customize the report type as needed.

This section lists all the report types that Ask Zia can come up with.

Numeric KPI Widgets

When you ask for a single metric such as last year's sales or profit, Zia will return the answer as a KPI. You can add this to your dashboard by clicking the Dashboard icon in the top right. 

Charts

Zoho Advanced Analytics supports creating a wide range of chart types using Ask Zia. 

Auto Selected Charts

Ask Zia will automatically identify the appropriate chart type based on the questions that you ask. 

Line Chart

When you ask for a series trend across a period, Zia will choose a line chart. 

Bar Chart

Bar Chart will be selected when you want to compare metrics across discrete groups. 

Selecting Charts

Apart from the auto-selected charts, you can also choose the appropriate chart type that best suits your scenario. You can choose the chart type by adding the corresponding keywords in the question. You can also select the chart type using the chart chooser. The following table explains how to select various chart types. 

Chart TypesExamplesKeywords

Stacked Bar 

Choose a Stacked Bar chart to analyze the patterns and trends in your data by comparing the parts of your dataset to the whole.

Monthly Store Sales and Online Sales for 2020 as a stacked bar chart

  • Stacked Bar
  • Stacked 

Pie Chart

Choose Pie chart to represent the contribution of each value to the overall total expressed in percentage. 

Show me the customer distribution by tags as a pie chart

  • pie
  • pie chart
  • semi pie
  • half pie
  • semi pie chart
  • half pie chart
Ring Chart

Show me the customer type count as a ring chart

  • ring
  • ring chart
  • semi ring
  • half ring
  • semi ring chart
  • half ring chart

Bubble Chart

Choose a Bubble chart to highlight the magnitude/weight of a data point, using the size (area) of the bubble.

Show me the sales of each product category by Billing State as a bubble chart

  • bubble
  • bubble chart

Bubble Pie 

Choose a Bubble Pie chart, when you want to plot a data series as a bubble chart, with each bubble sub-divided into proportional pies.

Show me the orders count by financial status for each year as a bubble pie chart

  • bubble pie
  • bubble pie chart

Combination Chart

A combination chart with a bar and a line chart will be chosen, when you ask for a combo chart. 

Show me the orders count by sales across months as a combo chart

  • combo chart
  • combination chart

Area Chart

Area chart helps you to compare data magnitudes. 

Orders count by source name by year as an area chart

  • area
  • area chart

Funnel Chart

The Funnel chart is used to represent a progressive flow/reduction of a business metric across phases. 

Show me the shipment status as a funnel chart

  • funnel
  • funnel chart

Web Chart

Choose Web chart to study the comparison between different data series

Budget vs Spending across Services as web chart

  • web
  • web chart

 

Geo Map Visualizations

When your data set has Geodata and you ask for a metric across the region, Zia will choose Geo Charts. The following are the supported Geo Chart types,

Chart TypesExamplesKeywords

Map Scatter Chart

Map Scatter chart will be plotted by default when you ask for data across the geo region.

Show me the stores by billing city as a scatter map chart

  • Map Scatter chart
  • Map Scatter
  • Geo Scatter chart
  • Geo Scatter 

Map Bubble Chart

You can choose a Map Bubble chart when you want to visualize the magnitude of the data across regions.

Show me the store sales by billing city as a bubble map chart

  • Map Bubble Chart
  • Map Bubble
  • Geo Bubble Chart
  • Geo Bubble

Map Pie Chart

You can choose a Map Pie chart to plot multiple bubbles across regions, with each region represented as an equal bubble, sub-divided into proportional pies. 

Show me the fulfillment status wise orders quantity by billing city as a map pie chart

  • Map Pie chart
  • Map Pie
  • Geo Pie chart
  • Geo Pie

Map Bubble Pie Chart

You can choose a Map Bubble Pie chart to plot multiple bubbles across regions, with each region represented as a proportional bubble by size (area), sub-divided into proportional pies.

Zia will choose the aggregate column in the query to determine the magnitude of the bubble. Other columns will be used to categorize data. 

Show me the orders count by status by billing state as a bubble pie map chart

  • Map Bubble Pie chart
  • Map Bubble Pie
  • Geo Bubble Pie chart
  • Geo Bubble Pie

Pivot Views

When you ask for multiple metrics grouped by multiple dimensions, a Pivot Table will be created. You can also choose to create a pivot view by using the keyword pivot, pivot view, and pivot table in the query. 

Summary Views

When you ask for a summary across multiple dimensions, a Summary View will be created.