Skip to main content

Sheet view

Sheet view in analyze mode.

You can open a sheet from the app overview. In sheet view, you can do the following:

  • Analyze with the app. You make selections in the visualizations and go into detail in your data to gain insights.
  • Take snapshots of visualizations. You use the snapshots for building stories in data storytelling.
  • Develop, or edit the app. You create sheets and visualizations to be used for data analysis. You cannot edit sheets of a published app, but if you have the correct permissions, you can create your own private sheets. You can also load another data file into the app.

The status of an app (published or not) affects what options are available in the menus and edit panel. For example, once the app has been published, you cannot:

  • navigate to the data manager or the data load editor
  • add data
  • edit the app or open app options

Analyzing

You start analyzing data on a sheet by making selections in the visualizations. You can quickly see and move around among the sheets with the sheet navigator.

Working with data insights in analysis view.

Sheet view with visualizations.

A: The toolbar

The toolbar contains the navigation menu, the global menu and other useful commands.  

Toolbar options
UI item Description

Global menu with navigation options, and actions that you can perform in your app.

For more information about tabbed browsing and the global menu, see Navigating using tabs.

More

Show or hide app information, where you can choose to edit app information or open app options and style your app.
Prepare

Prepare your data. You can select Data manager, Data model viewer, or Data load editor.

The options are not available in a published app, unless you are the owner of the app. In that case, you can only open the Data model viewer.

Analyze

Analyze your data. You can select Sheet or Insights.

Narrate

Tell a story with your data. You can select Storytelling.

Bookmark Access to all bookmarks in the app, and create a new bookmark.
Edit Edit sheet.
App objects Access to all sheets in the app and to creating a new sheet using the sheet navigator.
Previous Previous sheet.
Next

Next sheet.

See also:

B: Selections bar

The selections bar with tools for working with selections.

Selections bar options
UI item Action
Selections - History Step back in selections.
Selections - step forward Step forward in selections.
Selections - Clear all Clear all selections.
Selection search

Open smart search to search in the entire data set.

For more information, see: Using smart search

Selections - Current Open the selections tool, which is an extension of the selections bar.

For more information, see Exploring with selections and Using the selections tool.

C: The sheet

The sheet with visualizations.

For more information about sheets, see Structuring an app using sheets.

D: Selections tool

Access the selections tool.

For more information, see Using the selections tool.

E: Menu options

Hover menu with options.

Take snapshots

To take a snapshot of the visualization.

For more information, see Collecting insights for stories using snapshots.

Exploration menu

To change visualization properties without making selections or editing the sheet.

For more information, see Visual exploration.

Full screen

To explore data on a detailed level you can expand and work with one visualization at a time on the sheet.

Develop (edit)

You enable editing of the sheet and its visualizations by clicking Edit Edit sheet in the toolbar. The properties panel opens on the right.

Tip: You can also start editing by right-clicking a sheet in the app overview or the sheet navigator, and selecting Edit from the shortcut menu.

In an unpublished app, the left-hand panel contains assets such as measures, dimensions, fields and charts. You can create measures and dimensions from the assets panel, to use when building visualizations.

In a published app, the left-hand panel contains pre-made and ready-to-use master items (measures, dimensions and visualizations) and charts. You cannot update the existing sheets of a published app, but you can create new sheets to further develop the app.

Tip: If the panel on the left is collapsed, click one of the assets in the panel. If the properties panel is hidden, click Show properties open right panel in the lower right-hand corner.
Edit view of a sheet of an unpublished app, with the assets panel to the left and the properties panel to the right.

Sheet view with visualizations.

A: Assets panel

In the assets panel of an unpublished app you find fields to use when creating dimensions and measures, and charts to use when creating visualizations. You can also use custom objects to create visualizations. You can save dimensions, measures and visualizations as master items for reuse.

In a published app, you find pre-made and ready-to-use master items (measures, dimensions and visualizations). You also find charts and custom objects to use when creating your own visualizations.

For more information, see Assets panel.

B: Search

Use Search in the assets panel to search all items.

For more information, see Searching in the assets panel.

C: Selected

A selected visualization with resizing handles.

For more information, see Searching in the assets panel.

D: Properties

Properties of the selected visualization or the sheet. The properties for the sheet is shown if you have not selected a visualization.

For more information, see Creating and editing visualizations.

E: Edit items

Cut, copy, paste, and delete.

F: Undo and redo

Undo and redo your actions.

For more information, see Undoing and redoing actions.

G: Overview

Open the variables overview.

For more information, see Using variables in expressions.

Options menu

You can open the options menu by:

  • Right-clicking on a chart.
  • Clicking the hover menu More.

Menu options will be different depending on:

  • Whether you are editing or analyzing (viewing) charts in an app.
  • The chart type.
  • The privileges that have been assigned to you by your administrator.
Options menu

Options menu

The menu will look different if you have touch screen mode enabled on a supported device. You can disable touch screen mode in the global menu.

Touch gestures in the sheet view

The table describes the touch gestures that are used in the sheet view.

Touch gestures
Touch gesture Action
Long-touch and release Open the shortcut menu
Long-touch a visualization Open the options menu
Swipe Scroll lists and visualizations
Pinch Zoom in or out on visualizations
Two-finger tap Select an interval in a list, table or bar chart axis
Two-finger swipe Pan a scatter plot visualization
Three-finger tap Reset the zoom level of a scatter plot visualization