Skip to content

Data layers

A story analyses one dataset: a flat table of dimensions and metrics. Data layers is where that dataset comes from and where you check it.

Web app

In the web app, a data layer is a flow that you build from blocks:

  1. Sources bring the data in: a file, a Google Sheets spreadsheet, a data warehouse, an analytics tool… See Connect a source.
  2. Actions clean and combine it: rename and retype columns, append or join sources, filter, aggregate… See Clean and transform.
  3. The Datama block, at the end of the flow, sends the result to your story: it says which columns are dimensions and which are metrics, and how the metrics combine into your KPI. See Define your metrics.

Looker Studio, Tableau, Power BI, Qlik, Excel, Google Sheets

In a BI tool or a spreadsheet, the dataset is the fields you drop on the visual. Prepare it in the tool itself; see your environment for how to add fields.

Whatever the environment, the dataset must follow the data requirements.

The Data layers button of the story header opens the dataset that the story analyses.

Control Effect
Sample / Unique Sample shows the rows of the dataset. Unique lists the distinct values of each column, side by side; click a column header to sort them.
Search Keeps the rows where a cell contains the text, whatever the case.
First … rows How many rows each page shows: 10 by default, up to 200.

The footer gives the size of the dataset, in rows and columns, and when it was created.

When the dataset is embedded in the story, or editable, you can also change it in place:

  • double-click a cell to edit it. In a number or true/false column, the value you type is converted to that type;
  • paste a range copied from Excel or Google Sheets: it fills the cells from the selected one, and adds rows when needed. Columns beyond the table are ignored.

Your changes are applied when you close the panel, and the modules of the story are computed again.

Calendars are datasets of events (campaigns, holidays, incidents) that Datama lays over your KPIs. See Calendars.