Data analyst
Data analyst answers a question about your data the way an analyst would. You ask in plain words ("which city had the biggest rise in new cafes month over month?"); xMap AI looks at the field names and the first rows, writes a small program, and the program runs on all the items (up to 5,000) in a sandbox with no access to the web, your accounts or anything else. If the program fails, the error goes back to xMap AI to fix it, up to 3 times. The answer is written from what the program worked out only: a sentence with a number that is not in the result is left out. You get the answer, the result table and a chart, and the program itself under How it worked it out.
In the editor: Answers a question about your data the way an analyst would: xMap AI writes a small program over the items that reach it (or a table in My data), runs it on all of them in a sandbox with no access to the web, files or anything else, and answers from what the program worked out, with a table and a chart. A program that fails is sent back to be fixed, up to 3 times. The program shows in the run under How it worked it out. Use {{analysis}} in an Email or a Slack message after it.
Settings
Question
Text, several linesThe question, in plain words. {{field}} puts in a value from the first item, for example the city a webhook sent.
In plain words. {{field}} puts in a value from the first item.
Needed before the flow can run.
Work on
Pick oneWhat the program works on: the items that reach the block, a table or saved list from My data, or both (for example the places found and your own stores beside them).
Up to 5,000 items that reach this block.
- The items that reach it
- A table in My data
- Both
Table
A settingThe table or saved list from My data.
A table or saved list from the My data page.
Needed before the flow can run.
Give back
Pick oneAn answer and a table: the answer as {{analysis}} and the result rows as items. With a chart: the same, and the chart shows in the run and in Results. The items with new fields added: each item goes on with the fields the program works out, such as its share of its city or its rank.
The answer as {{analysis}}, and the program’s result rows as the items (up to 500), with the answer first. The chart shows in the run and in Results.
- An answer and a table
- An answer, a table and a chart
- The items with new fields added
What comes out
Each item that leaves the block carries these fields, to use in the blocks after it as {{field}}.
The answer
Always.
analysis: The answer in two to five sentences, as {{analysis}} in an Email or a Slack message after the block. The first item carries it too.
The result rows
Give back: an answer and a table (with or without a chart).
(the program’s fields): One item per result row, with the fields the program named.
How to use it
Where rivals grow fastest
Each week, the cities where new rival stores rose most against the month before, with the table and the answer at the top of the email.
Score my territory
Your own accounts table, summed and compared per rep and city by a program, in a report.
Price per m2 by district
Medians and spreads the ready blocks do not work out, with a chart of the districts.
Busiest sites against my stores
The places found and your own stores table side by side, so the program can count what is near each store.
Rating spread by type of place
A table and a chart of how each type of place is rated, worked out exactly from every place found.
Good to know
- xMap AI sees only the field names, their kinds and the first 20 rows; the program runs on all of them on the server.
- The program runs in a sandbox with no network, files or secrets, 3 seconds of computing and 32 MB at most. It never runs anywhere else.
- Numbers in the answer come from the program’s result only; a sentence with any other number is left out, and the step says so.
- Credits: like a whole-list report (per item read, at most 300 counted, plus the tokens) and a small charge for each program written. A test run runs it too, and charges the same.
- In Results and Ask xMap, a question the ready charts cannot answer is offered to the Data analyst over your results, with the price first; Pin to a dashboard runs its program again on fresh results each time, free.
Works well with
- xMap LLM: Tell the AI what to do in plain words.
- My data: Brings in a table you uploaded or a list you saved on the My data page: your stores, customers, target accounts or sites.
- Email: Sends one email per run with all the items, or one email per item.
- Make a report: Turns the items that reach it into a clean PDF report with your logo and colour: the summary an xMap LLM block wrote for the whole list, the figures, charts of kinds and cities, a map and the list.
- Custom code: Your own JavaScript, for what the other blocks cannot do: change, add or drop fields, filter and reshape the items.
Help articles
- The Data analyst: questions answered with a program: Ask a question about your data in plain words; xMap AI writes a small program, runs it on every item and answers from what it worked out.
Read more
- Account-based marketing for multi-location businesses: one account, many branches: Treat a brand with dozens of branches as one account: map its footprint, tier it, find head office buyers, and turn branch openings into reasons to get in touch.
- How to turn a business count into a chart people understand: A count of shops or clinics means little as a bare number. Which chart to draw, what to put on each axis, and how to keep the base of every figure honest.
- How office landlords turn local hiring into tenant leads: Office tenant leads from job postings: which hiring patterns hint that a company will need more space, how to check them, and how to get the list every week.
Try it
Build a flow with Data analyst on the home page, no account needed, or book a call. Try it live