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
- Geo Map Visualization
- Pivot Views
- Summary Views
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.
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.
When you ask for a series trend across a period, Zia will choose a line chart.
Bar Chart will be selected when you want to compare metrics across discrete groups.
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.
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
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
Show me the customer type count as a ring 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
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
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
Area chart helps you to compare data magnitudes.
Orders count by source name by year as an area 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
Choose Web chart to study the comparison between different data series
Budget vs Spending across Services as 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,
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 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 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 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
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.
When you ask for a summary across multiple dimensions, a Summary View will be created.