Visualizing Data

This topic describes how to visualize your worksheet data results using charts and dashboards.

In this Topic:

Working with Charts

Charts transform your query results into visualizations that communicate logical relationships and lead to more informed decision-making. They enable you to quickly identify and understand patterns and outliers in data.

Snowsight supports the following types of charts:

  • Bar charts

  • Line charts

  • Scatterplots

  • Heat grids

  • Scorecards

View Charts

When you execute a query that returns results, click the Charts tab. Worksheets create a chart for you automatically based on your results. Currently, each query supports creating a single chart.

Choose a chart type to get started. You can change the type later. To adjust your chart, select the appropriate section in the inspector to make changes. All changes are saved automatically.

By default:

  • Axes minimums and maximums are set to Auto.

  • Ticks are set to Auto when relevant.

  • Axes are unlabeled.

  • There are advanced fields for some charts as well.

These aspects of a chart can be edited to fit your needs.

Charts and New Query Results

As long as the columns in your chart remain in your result set, your chart updates automatically. If column names change, your chart may break. Charts indicate any columns it cannot locate, so you can edit either the chart or your query.

Aggregate and Bucket Data

Charts simplify grouping numbers, dates, and timestamps of more or less continuous values into various buckets. For example, suppose your query retrieves per-day data over a period of time. Without modifying your query, you can easily select a different bucket of time (e.g. weekly or monthly data) in the inspector panel to change the time dimension of the results displayed in the chart.

Charts can bucket by date, week, month, and year for date columns. For numeric columns, charts can bucket by integer values.

Switching from daily to weekly bucket

Charts use aggregation functions to determine a single value from multiple data points in a bucket. These functions are as follows:

  • average

  • count

  • minimum

  • maximum

  • median

  • mode

  • sum

Download Charts

Use the download button in the inspector to download your chart as a PNG file.

Working with Dashboards

Dashboards are flexible displays of one or more charts (in the form of tiles, which can be rearranged). Charts are always produced by worksheet queries that return results.

Dashboards work at a variety of sizes with minimal configuration.

Note

Dashboards can only include worksheets you own; they cannot include shared worksheets.

Create Dashboards

Creating a Dashboard from Existing Worksheets

Navigation

Home (wksts1) » My Worksheets (or open a local worksheet under Recent or in Folders) » <worksheet_name>

  1. Click the name of the open worksheet in the upper-left corner of the page, and click Move to » + New dashboard. The New Dashboard dialog opens.

  2. Enter a name for the new dashboard.

  3. Click the Create Dashboard button. A dialog displays the worksheet.

  4. Click the <dashboard_name> button in the upper-left corner. The new dashboard displays a chart for the worksheet you added.

    Note

    • When a worksheet is moved to a dashboard, it is no longer listed under My Worksheets. The worksheet can only be edited from within the context of the dashboard.

    • If permissions were previously granted on the shared worksheet link, these permissions are revoked. You can share the dashboard link but can no longer share the worksheet link separately. For information about shared worksheet links, see Sharing Worksheets and Dashboards.

To add additional tiles to the dashboard:

  1. Open the worksheet you want to add to the dashboard.

  2. Click the name of the open worksheet in the upper-left corner of the page, and click Move to » <dashboard_name>. If a permission was set on the shared worksheet link, a dialog asks you to confirm you approve dropping the permission.

    The worksheet is added to the dashboard. A tile showing the chart for the worksheet is displayed in the dashboard.

Edit Dashboards

Navigation:

Home (wksts1) » Dashboards » My Dashboards (or open a local dashboard under Recent) » <dashboard_name>

Rearranging the Order of Charts

When a worksheet is added to a dashboard, its chart is added as the last tile. To rearrange tiles, click and drag a tile into the desired position in the dashboard using the mouse left button or the touchpad.

Editing Charts

  1. Click the edit button in a tile () and click View chart. The chart opens.

  2. Change the chart type, modify the data displayed in the chart, or otherwise edit the chart. For instructions, see Working with Charts (in this topic).

  3. When you are finished editing the chart, click the — Return to <dashboard_name> link in the upper-left corner of the chart.

Editing Worksheets

  1. Click the edit button in a tile () and click View query. The worksheet opens.

  2. Edit the query as desired. For instructions, see Querying Data Using Worksheets.

  3. When you are finished editing the worksheet, click the — Return to <dashboard_name> link in the upper-left corner of the worksheet.

Changing the Tile from a Chart to Query Results

By default, when a worksheet is moved to a dashboard, its tile displays the chart. To display the query results instead:

  1. Click the edit button in a tile () and click Unplace Tile. The tile is removed from the dashboard.

  2. Click the + button in the upper-left corner of the dashboard. A dialog displays a graphic representation of a chart and query results for each worksheet in the dashboard.

  3. Click and drag the query results representation as a tile into the desired position in the dashboard using the mouse left button or the touchpad.

Deleting a Tile

Warning

Deleting a tile from a dashboard deletes the underlying worksheet altogether. This action cannot be undone.

  1. Click the edit button in a tile () and click Delete. A confirmation dialog opens.

  2. Click the Delete button to permanently delete the tile and worksheet from the dashboard.