Skip to main content

Build dashboards

Prepare columns

Hide, classify, and group a dataset's columns.

Before you build, decide which of a dataset's columns authors can chart, and which hold personal or sensitive data. You can also link related columns across datasets. This page covers the settings for each column, where to change them, and what they change.

Before you start​

You need a dataset. See Connect and upload data. You can set columns while creating the dataset, in the Shape step, or at any time after on its Columns tab.

What you can set for a column​

SettingChoicesWhat it changes
VisibilityVisible, Filter only, HiddenVisible columns can be charted and filtered on. A Filter only column is offered for filters, not for charts. A Hidden column is not offered to people building charts.
ClassificationNone, PII, SensitiveMarks a column as personal data (PII) or otherwise sensitive. See below.
DescriptionFree textExplains the column to other authors.
MotifsAny motifLinks the column to columns that mean the same thing in other datasets.

Visibility only shapes what authors are offered. It is not a security control: which rows a customer sees is set by the dataset's tenant key, not by hiding columns.

What PII and Sensitive change​

Classifying a column PII or Sensitive changes what viewers get and what authors are asked:

  • When viewers open or download the rows behind a chart, these columns are left out. Only authors and admins see them, inside GOAT.
  • Adding a filter on such a column asks you to confirm first. Viewers can then see the column's values in the filter's choices, though never its rows.
  • In an embedded dashboard, drilling into a value of such a column works only on charts whose author confirmed it when saving the chart.

Classifying a column that existing filters already use asks you to confirm, and lists those dashboards. Changing a column between PII and Sensitive asks nothing.

Charts already saved are not asked. After you classify a column, open each chart that drills or shows rows on it in the Chart Builder, and save it again, confirming. Until then, embedded viewers' drills on that column are refused.

In the Shape step, while creating a dataset​

To open the Shape step, choose Shape data under More options on Name and access. With Advanced on in "Where is the data?", it opens by itself.

Shape the data shows one row per column, with Field, Type, Shape, Visibility, Class., Description, and Motifs.

  • Shape changes how a column is stored: Cast to another type, Expand rows of a list, or Flatten fields of a nested record. It is available only when GOAT keeps its own copy of the data. For Live connect and files read in place, it shows a dash.
  • Visibility, Class. (the classification), and Description work as described above.
  • Select several rows to Hide or Classify them together.
  • The ⋯ menu on a row, or a right-click, offers Add to motif.

For CSV files, GOAT may ask you to choose a date format for a column it cannot read for certain. Choose one, or Keep as text.

On the Columns tab, after the dataset exists​

Open the dataset and its Columns tab. The table shows each column's Visibility, Classification, and Description, and flags such as tenant key in the In the table column.

  1. Change a column's settings in its row, or select several columns and use Set visibility or Set classification.
  2. Choose Save column settings.

A column's type and nesting cannot be changed here once data has loaded; that needs the table rebuilt, which the Tenancy tab handles. Date formats are changed from the Data tab, with Change date formats.

Motifs​

A motif links the columns that mean the same thing in different datasets, such as a region column in Orders and in Support tickets. A chart built on one can then be found from the other.

  • To add a column to a motif, use Add to motif in the Shape step, or the Motifs section of the Columns tab.
  • To see every motif, open Semantics, then Motifs. New motif creates one; each motif's row lists its member columns and the charts that use it.

Deleting a motif does not break charts that use it.

The field dictionary​

Semantics, then Fields, lists every column of every dataset in your install in one place. Use it to find a column, and to give it a description, synonyms, visibility, and classification without opening each dataset. Changes save as you type.

Common problems​

What you seeWhat to check
Shape shows a dash for every columnThe dataset reads its table in place. Shape needs a managed copy.
A column does not appear when building a chartIts visibility is Hidden, or Filter only.
Saving a classification asks you to confirmFilters already use the column. Read the list, then confirm or cancel.
A column is missing from the rows viewers downloadIt is classified PII or Sensitive.
Viewers' drills fail after you classified a columnSave each chart that uses the column again, confirming.
GOAT documentation

Type to search.