Skip to content

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 sayWhat 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 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:

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:

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?

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?

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 seeWhat has happenedWhat to do
The assistant says a field doesn’t exist and suggests othersWhat you asked for isn’t called that in that reportPick 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 dataAsk on another report that has it
It says the group is of another type of recordYou are asking about a group of items in a customers report, for exampleUse 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 itAsk it for the list of the ones you have
It doesn’t offer to saveYou lack the Groups and segments permission with createAsk whoever manages permissions
The step takes a while and isn’t addedThe count took more than 20 secondsNarrow first by dates or by a tighter field
The query no longer opensIt had gone more than seven days without being usedAsk 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

More about Assistant