Dashboards
The
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 .
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 to execute the query.
- To save the virtual dataset, click the next to the button, and select .
For a list of available functions and syntax guidance, please reference the SQL in BigQuery documentation.
The
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 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 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 and use the SCOPING panel to apply filters.
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.
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.