Go to Benchling
All Collections
Insights
Insights
Build queries and visualizations to understand your experiments, entities, and entries
+4
26 articles in this collection
Written by
Hannah Park,
Tara Lee,
Sanjay Saraf
and 4 others
Using Insights
Insights basics
Overview of Insights capabilities and limitations
Written by
Sanjay Saraf
Updated over a week ago
Detect outliers on logistic regressions
Exclude outlier data points on scatter plots with logistic regression lines
Written by
Tara Lee
Updated over a week ago
Managing Insights dashboards and queries
View, duplicate, rename, and delete Insights dashboards and queries
Written by
Andrew Collins
Updated over a week ago
Running Insights queries
Use block templates or custom SQL to query your data
Written by
Andrew Collins
Updated over a week ago
Search for schemas to use in Insights queries
Find schemas using the schema browser and entity diagram
Written by
Sanjay Saraf
Updated over a week ago
Creating parameters
Filter Insights results using parameters
Written by
Andrew Collins
Updated over a week ago
Visualizing your Insights data
Create graph, chart, and diagram visualizations for your Insights data
Written by
Andrew Collins
Updated over a week ago
Embedding Insights dashboards into the registry
View entity-specific insights directly in the registry
Written by
Sanjay Saraf
Updated over a week ago
Using dynamic pivots in Insights
Sort, reorganize, and restructure your table data
Written by
Jenny Dao
Updated over a week ago
SQL basics video series
Watch videos explaining querying in Benchling Insights
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
Insights FAQ
Helpful answers to frequently asked questions
Written by
Andrew Collins
Updated over a week ago