This guide walks you through creating a dashboard to compare the output data from a plate reader at two different timepoints, which has been ingested into Ganymede. This dashboard leverages the same data processed in the Build a Flow guide. By the time you're finished, you'll have converted raw data to a dashboard that looks like this:
To do this we'll proceed through the following steps:
- Sign into Ganymede
- Set up virtual datasets
- Build charts from those virtual datasets
- Add those charts to a dashboard
Step 1: Sign into Ganymede
Thebutton should be available once authentication is configured for your tenant, which is generally going to be a web address accessible via any web browser with the URL https://<your_tenant>.ganymede.bio.
You may need to enable pop-ups for Ganymede or disable any ad-blocking software for the ganymede.bio domain.
Step 2. Create virtual dataset for this visualization
In order to create our dashboard we'll need to create two datasets for displaying, a Quickstart_Absorbance_Change_Absolute_Differences dataset and a Quickstart_Absorbance_Change_Run_Parameters dataset.
Quickstart_Absorbance_Change_Absolute_Differences is a table containing absorbance measurements from two different plates; Quickstart_Absorbance_Change_Run_Parameters contains temperature and timepoint metadata associated with each plate.
Step 2a. Load plate reader data for charting
Hover over SQL in the top menu bar and click on SQL Lab. This should bring you to a SQL editor that lets you preview tables, and results of SQL queries:
Fill in the SQL Editor with the query below and clickto execute SQL.
-- Quickstart_Absorbance_Change_Run_Parameters table
SELECT field, run_diff, left(field, 1) as row, cast(right(field, length(field)-1) as int64) as column
UNPIVOT (value for run IN (run1, run2))
WHERE field not in ('Time [s]', 'Temp. [°C]', 'Cycle Nr.')
ORDER BY row, column
After doing so, the SQL editor should return the results of the query:
Save a virtual dataset to make it available for graphing by clicking on theto the right of the button. Save the dataset as Quickstart_Absorbance_Change_Absolute_Differences.
Step 2b. Load plate reader metadata for charting
Navigate back to the SQL Editor and repeat step 2a with the query below, saving the output virtual dataset as Quickstart_Absorbance_Change_Run_Parameters.
-- Quickstart_Absorbance_Change_Absolute_Differences table
SELECT field, value, trim(run, 'run') as run_number
UNPIVOT (value for run IN (run1, run2))
WHERE field in ('Time [s]', 'Temp. [°C]', 'Cycle Nr.')
Step 3. Create run parameters pivot table
Navigate to the Datasets tab in the top bar and search for "Quickstart" to find the virtual datasets you created.
Click on the Quickstart_Absorbance_Change_Run_Parameters table. This should bring you to a page for assembling a chart:
Click on the View All Charts text in the middle of the screen and select the Pivot Table chart type.
Assemble the pivot table by dragging the fields in the virtual table into the Query section. Name the chart "Run Parameters" as shown below.
Clickto save the chart and add to a new dashboard named "Absorbance Analytics."
Step 4. Create plate reader heat map
Navigate to the Datasets tab in the top bar and select the "Quickstart_Absorbance_Change_Absolute_Differences" virtual dataset created earlier.
Click on View All Charts and select "Heatmap" as the visualization type.
Assemble the heat map as shown below, and name the chart "Plate Absorbance Change."
Clickto save the chart and add the chart to the "Absorbance Analytics" dashboard created in Step 3.
Step 5. Orienting the dashboard
Click on the Dashboards button in the top bar and select the Absorbance Analytics dashboard.
Arrange the dashboard by clicking on thebutton in the top right hand corner of the screen. In the edit mode, tables and graphs can be resized and moved to different rows.
When you're satisfied with the arrangement, click SAVE. You've just built your first dashboard in Ganymede!