Dashboards

The

Dashboard

page offers charts and dashboard visualizations based on data stored within Ganymede.

 

To assemble a dashboard:

• Add a dataset from the environment or create one via SQL query.
• Create a chart from the dataset.
• Save the chart to a specified dashboard.
• Modify dashboards and chart layouts by selecting the corresponding dashboard from the Dashboards tab in the top menu bar.

Adding a Dataset

Before creating charts, you will need to add datasets from the environment. These can be either (Physical Datasets) or Virtual Datasets (created via an ANSI SQL query).

Adding Physical Datasets

Physical datasets are outputted by Flows. To add a physical dataset:

• Click on the Datasets button in the top bar:

• Choose a database, schema, and table. Then click
  CREATE DATASET AND CREATE CHART
  .

Adding Virtual Datasets

Virtual datasets are created by querying existing tables in Ganymede.

• Hover over SQL in the top menu bar and click on SQL Lab. This should bring you to a SQL editor, where you can preview tables and run SQL queries.

• Enter your SQL query, select the number of rows to preview, and click
  RUN
  to execute the query.

• To save the virtual dataset, click the
  next to the
  SAVE
  button, and select
  Save Dataset
  .

For a list of available functions and syntax guidance, please reference the SQL in BigQuery documentation.

Saving queries

The

SAVE

button saves SQL queries for future edits, but does not register a query as a virtual dataset.

Creating a chart

Charts can be created from physical or virtual datasets.

To create a chart:

• Hover over Data in the top menu bar and click on Datasets. Select a dataset from the list, which will open the chart creation pane:

• Use the DATA tab to specify chart type and to pivot or aggregate data. The CUSTOMIZE tab allows you to annotate axis labels, specify axis formats, and set the chart title.

Saving charts to dashboards

Once the created chart is ready, click SAVE in the upper-right hand corner to add it to a dashboard:

Calculated columns

Calculated columns are useful for refining data visualization. Examples include:

• Taking the floor or ceiling of a variable to truncate data outside of a desired range
• Categorizing or subsetting data through string manipulation
• Extracting values for aggregation

To create a calculated column:

• Hover over the three dots to the right of the dataset on the Chart Creation page and click Edit Dataset.

• Select the Calculated Columns tab to add new columns to the dataset. Specify the field definition using a SQL expression.

Calculated Column flexibility

Calculated columns are more flexible than what is found in other BI tools offering similar functionality. Beyond aggregation, these fields can be filtered on, sorted by, and/or used to categorize data.

Editing dashboards

To edit a dashboard:

• Select Dashboards from the top menu bar and navigate to the desired dashboard. Click
  EDIT DASHBOARD
  to resize and rearrange the layout of different charts.
• To filter data within graphs, click the icon on the left side of the dashboard, then select
  Add filters and dividers
  and use the SCOPING panel to apply filters.

Permissions for editing datasets

Dashboards can only be edited by their owner(s). One method for multiple users to avoid conflicting dataset modifications would be for users of shared datasets to create virtual datasets for their own use.

Tables referenced by dashboard filter

The SCOPING tab on the filters modal allows users to specify which graphs the filter applies to. Note that if 2 charts are backed by different datasets which share a field name, a single filter can be used to manipulate both tables simultaneously.