Group 65
Go to Benchling
All Collections
Insights [Enterprise]
Insights [Enterprise]
Build queries and visualizations to understand your experiments, entities, and entries.
+3
27 articles in this collection
Written by
Hannah Park,
Sanjay Saraf,
Andrew Collins
and 3 others
Using Block Templates in Insights
Add tables and charts to Insights dashboards without writing SQL
Written by
Rebecca Conway
Updated over a week ago
Introduction to Insights
Written by
Sanjay Saraf
Updated over a week ago
Writing SQL in Insights
Videos walking through querying with Benchling Insights
Written by
Sanjay Saraf
Updated over a week ago
Managing Blocks within Insights
How to manage blocks within the Insights tool
Written by
Andrew Collins
Updated over a week ago
Insights Permissions
Guide reviewing the permissions for the Insights
Written by
Andrew Collins
Updated over a week ago
Insight Navigation and Orientation
Basic guide to orientate new users with navigating the application
Written by
Andrew Collins
Updated over a week ago
Running a SQL Query
How to run a SQL Query in the Insights tool
Written by
Andrew Collins
Updated over a week ago
Configuring Visualizations
How to set up specific graph visualizations within the Insights application.
Written by
Andrew Collins
Updated over a week ago
Creating Parameters
What are Parameters useful for?
Written by
Andrew Collins
Updated over a week ago
Duplicating or Deleting a Dashboard in Benchling Insights
You can duplicate and delete dashboards, and their associated queries, within Benchling Insights.
Written by
Andrew Collins
Updated over a week ago
Using Dynamic Warehouse Diagrams within Insights
Understand the relationships among your schema tables in Benchling
Written by
Sanjay Saraf
Updated over a week ago
How do I configure Insights Registry Embedding?
Embed your Insights Dashboards into the Registry to get contextual data about your entities!
Written by
Sanjay Saraf
Updated over a week ago
Querying FAQ
How do I convert row_index and column_index to well positions?
Well and Box Positions
Written by
Namitha Patil
Updated over a week ago
How do I join data from different Benchling Applications?
Key Joins for Applications in Benchling
Written by
Namitha Patil
Updated over a week ago
How do I aggregate data across different organizations?
Combine data across Benchling organizations
Written by
Hannah Park
Updated over a week ago
How and when should I use schema specific tables or the single “registry_entity” table?
Schema specific table vs. “registry_entity” table
Written by
Anshi Saxena
Updated over a week ago
How do I make a date range for a time series with parameters?
Filter on Date Range
Written by
Anshi Saxena
Updated over a week ago
How do I add timezones to my Datetime values?
Adjust Timezone for Datetime columns
Written by
Anshi Saxena
Updated over a week ago
How come my division yields wrong numbers?
Specify precision on number columns
Written by
Anshi Saxena
Updated over a week ago
How do I query over JSONB arrays like ["seq_D3fZa648", "seq_bVWwI73e"]?
Separate data in JSONB Array columns
Written by
Hannah Park
Updated over a week ago
How do I change the order of query results of alphanumeric values?
You can use SUBSTRING to extract a certain part of a value and use that to order
Written by
Hannah Park
Updated over a week ago
How is “PARTITION BY” different from “GROUP BY”?
Window Functions vs. Group By
Written by
Hannah Park
Updated over a week ago
How do I make my parameter work when it is a null value?
Return data when the parameter is empty
Written by
Anshi Saxena
Updated over a week ago
What is the difference between tables that are suffixed with $raw vs. not?
Raw Tables vs Non-Raw Tables
Written by
Hannah Park
Updated over a week ago
How do I search for multiple values in a parameter?
Filter data on multiple values
Written by
Anshi Saxena
Updated over a week ago
How do I set up partial text matching for Parameters?
Use CONCAT and LIKE/ILIKE
Written by
Hannah Park
Updated over a week ago
How do I extract the date/timestamp from values such as “2020-06-19T21:23:26.990971”?
Convert Timestamp to Date
Written by
Hannah Park
Updated over a week ago