How do I ask the assistant to narrow a report and save it as a group?
The assistant works with reports just as you do in their window: it opens a query, adds steps to it from what you tell it in your own words, tells you where the remaining ones are from, gives you them as a PDF or in Excel and saves them as a group, as a segment or as a new report. It works for any report in the program: customers, items, invoices, due dates, *entries*…
What can I ask it about a report?
Everything you would do by hand with Query and Selection in the report window:
| You say | What it does |
|---|---|
| “Of the customers, which ones are in Valencia and haven’t bought this year?” | Opens a query on the customers report and adds two steps |
| “And of those, the ones in hospitality” | Adds one more step on what was left |
| “Only those that have item A01” · “those with a payment method starting with K” | Adds a step with a detail from another table: their sales lines, their payment method |
| “To these, add those with a payment method starting with D” | Adds a step that adds records to the ones that were left |
| “Remove those with a returned receivable” | Adds a step that takes records out of the ones that were left |
| “…or the ones in Alicante” | Extends the last step with another condition that is also valid |
| “No, drop the date one” · “Castellón, not Valencia” | Removes that step or swaps it for another |
| “Which provinces are they from?” · “how many are there per payment method?” | Tells you how the remaining ones are spread |
| “Sort them by amount, highest first” | Changes the order, without removing anyone |
| “Get the customers of those invoices” | Goes from the invoices to the customers behind them |
| “Give it to me in Excel” · “get it as a PDF” | Gives you the link to download it, with the steps applied |
| “Save them as a group called Trade fair 2026” | Proposes saving it, and saves it when you confirm |
| “Save this as a report” | Proposes a new report of yours with the steps inside |
Each step is written by the program, not by the assistant: what it tells you it has added —“Province is not ‘Valencia’”— is exactly what is applied, and it tells you how many records there were and how many are left.
If what you ask for cannot be known from the report data —“those with an Instagram page”—, the assistant says so instead of adding a similar step.
Can I ask the assistant to narrow by details from another table, or to add records to the ones I already have?
Yes. The assistant asks about the details of the report and about those of its related tables, just as you do with From which table in the Query panel of the report window (Reports → Reports):
- A detail of a record the row points to: “customers whose payment method starts with K”, “invoices of hospitality customers”.
- Something the record has several times: “those that have item A01”, “those with no invoice this year”, “those who have bought more than three times”, “those adding up to more than 1,000 euros”.
- Adding and removing: “to these, add those with payment method D” adds records to the ones that were left; “remove the ones in Valencia” takes them out. The step that adds reads “Plus those that: …” and the one that removes, “Minus those that: …”.
A complete example, on the customers report or on the invoices one: “only those that have item A01”, “now only the payment methods starting with K”, “to these, add those with a payment method starting with D”, “save it as a segment”. Each sentence is a step, and the segment saves all three.
How to do the same by hand: getting a report.
How do I ask it to narrow the report I have open?
From the report window (Reports → Reports, or your area’s reports page) there are two ways, and both end up in the same place:
- In the “AI query” box of the Query panel: write the sentence and press Ask. The assistant opens with it.
- In the assistant directly, with the report on screen: “remove those from Valencia”. The assistant knows which report you have in front of you and which steps you have, even if you haven’t pressed Query.
The step appears in the panel’s list as soon as the assistant adds it, and the table redraws itself. You can mix steps by hand and spoken steps, and switch them off, remove them or undo them in the same way. How the panel works: How do I narrow a report step by step?.
Can I ask without opening the report first?
Yes. From any screen, ask with the report in the sentence: “of the items, which ones haven’t sold in the last 90 days?”, “open a query on the due dates report”. It looks for the right report, opens the query and answers with how many are left and a few as a sample. If there are several similar reports, it asks you which one.
To see them all, ask it for the link —“open it for me”, “give it to me in Excel”—: it takes you to the report window with the steps in place, or gives you the PDF, the Excel file or the CSV.
How do I ask it to save the result as a group or a segment?
Tell it, with the name: “save them as a group called Trade fair 2026”, “save this as a segment of dormant customers”. If you don’t say which of the two, it asks you:
- a group stores which ones they are today: a fixed list;
- a segment stores the question, and each time it is used it says who meets it that day.
Saving is an action: the assistant shows you the card with what it is going to save and waits for you to press Confirm. Then it gives you the link to its record in CRM → Groups and segments.
The group is of the type of record in the report: some invoices give a group of sales documents. If what you want is their customers, say so —“save their customers”— and it moves to them first. What they are and how they are used afterwards: groups and segments.
How do I use my groups and segments by talking to the assistant?
- “Which customer groups do I have?” — it tells you yours and the ones shared with you, with how many each group has.
- “Who is in the Trade fair 2026 group?” · “what rule does the dormant segment have?” — it shows you its records or the steps of its rule and how many meet it today.
- “Starting from the Trade fair 2026 group, remove those who have already bought” — it opens a query with the ones in the group and keeps narrowing.
- “The ones in Valencia who are not in the bad payers group” — it uses the group as one more step.
- “Add these customers to the Trade fair 2026 group” · “put customer 000042 in the VIP group” — it adds records to, or removes them from, a group of yours: the ones left in the query, or specific ones by their code (up to 200 at a time). It is an action and is confirmed.
You cannot add records to a segment or remove them: its rule decides.
And from Claude, ChatGPT or another connected assistant?
It can do the same, if you have it connected (see connect an external assistant (in Spanish)) and you allowed it to make changes. Opening, narrowing, spreading and getting the data are queries; saving a group, a segment or a report, and changing the members of a group, are actions, which your assistant asks you to approve before sending them. They are not among the sensitive ones: they don’t wait in Powergest.
What do I need for it to work?
- The AI assistant enabled in your company. Without it, all of this is done the same way by hand in the report window.
- To narrow and get reports, being able to run them: the assistant only sees the reports and the fields your role can read, like you.
- To save or change groups and segments, the Groups and segments permission in CRM: with view it uses them, with create it creates them and with modify it changes their members. To save as a report, being able to create reports.
A query is yours and a working tool: nobody else sees it, and if you don’t use it for seven days it is deleted. What stays is what you save.
If something goes wrong
| What you see | What has happened | What to do |
|---|---|---|
| The assistant says a field doesn’t exist and suggests others | What you asked for isn’t called that in that report | Pick one of the ones it tells you, or say it another way |
| “It cannot be known from the report data” | The report doesn’t have that data | Ask on another report that has it |
| It says the group is of another type of record | You are asking about a group of items in a customers report, for example | Use a group of the same type, or move to those records first |
| “… does not exist, or is not yours and has not been shared” | The group was deleted, or belongs to someone else who hasn’t shared it | Ask it for the list of the ones you have |
| It doesn’t offer to save | You lack the Groups and segments permission with create | Ask whoever manages permissions |
| The step takes a while and isn’t added | The count took more than 20 seconds | Narrow first by dates or by a tighter field |
| The query no longer opens | It had gone more than seven days without being used | Ask for it again; if you want it for good, save it as a segment or as a report |
See also: Run a report · Groups and segments · Ask the assistant to do something