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:
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.
Axes minimums and maximums are set to
Ticks are set to
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.
Charts use aggregation functions to determine a single value from multiple data points in a bucket. These functions are as follows:
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.
Dashboards can only include worksheets you own; they cannot include shared worksheets.
Creating a Dashboard from Existing Worksheets¶
Worksheets » My Worksheets (or open a local worksheet under Recent or in Folders) » <worksheet_name>
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.
Enter a name for the new dashboard.
Click the Create Dashboard button. A dialog displays the worksheet.
Click the — <dashboard_name> button in the upper-left corner. The new dashboard displays a chart for the worksheet you added.
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:
Open the worksheet you want to add to the dashboard.
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.
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.
Click the edit button in a tile (…) and click View chart. The chart opens.
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).
When you are finished editing the chart, click the — Return to <dashboard_name> link in the upper-left corner of the chart.
Click the edit button in a tile (…) and click View query. The worksheet opens.
Edit the query as desired. For instructions, see Querying Data Using Worksheets.
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:
Click the edit button in a tile (…) and click Unplace Tile. The tile is removed from the dashboard.
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.
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¶
Deleting a tile from a dashboard deletes the underlying worksheet altogether. This action cannot be undone.
Click the edit button in a tile (…) and click Delete. A confirmation dialog opens.
Click the Delete button to permanently delete the tile and worksheet from the dashboard.