Applies to
- Enterprise
Use analyze data to generate charts and metrics
Answer ad hoc questions and visualize your progress in seconds. Create charts and metrics on the spot to unblock work and make better decisions — just ask the analyze data tool.
Access analyze data
To access the Analyze data panel, you should:
- Go to any sheet and select the Generate with AI tools icon in the right rail.
- Select Analyze data from the list of available tools.
- Ensure you saved your changes, if you made any.
- Type your question or request into the prompt box that appears. Be clear about the output or result you expect. As you type, you can see sample prompts for your reference.
- Alternatively, type in Suggest a question if you want to access sample questions specific to your sheet.
How to interact with analyze data
You can ask all your questions and make modifications in plain language. If the system needs clarification, it asks for it. You can reply in plain language.
If you feel the answers you’re getting aren’t what you expected, ask follow-up questions to refine the answers.
Ask questions that result in a single value output, such as What’s the total budget for the IT Department?
You can also visualize data as bar, line, or pie charts. To do so, ask our analyze data questions like Show me the budget across all departments or How many tasks is Person A assigned to?
If you ask analyze data to create a chart or metric, use the Explain this result button to access a step-by-step explanation of how the skill generated the response.
Sample questions
Use the following examples to get an idea of the types of questions you can ask analyze data.
Metrics
- How many issues are at risk?
- What’s the average cost of goods made in the USA?
- Who is the contact person for Project Acme?
Charts
- Compare the percentage of tickets for each assignee
- Show me a chart with the breakdown of tickets that started on each date
- Create a chart showing the number of tasks in each status
You can ask analyze data to create a pie, bar, stacked bar, or line chart.
Counts, percentages, and other requests
- How many tickets are assigned to Ariel?
- What percentage of issues submitted this month are complete?
- How many checked rows have three stars? (Applies if stars is a value in a symbol column)
Analyze data limitations
At the moment, analyze data can’t provide:
- Summaries, such as asking to Summarize this sheet
- Answers for the Auto-number and Duration column types, and for the duration between two Date columns
- Options to filter or highlight rows
- A way to download the answers or add them to a dashboard