FlowsBook a callSign inCreate free accountSign up
xMap AI

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 lines

The 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 one

What 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 setting

The 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 one

An 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

Retail

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.

Sales

Score my territory

Your own accounts table, summed and compared per rep and city by a program, in a report.

Real estate

Price per m2 by district

Medians and spreads the ready blocks do not work out, with a chart of the districts.

Operations

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.

Marketing

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

Read more

Try it

Build a flow with Data analyst on the home page, no account needed, or book a call. Try it live