Insights

Insights basics

Overview of Insights capabilities and limitations

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

Insights permissions overview

Determining user permissions and access in Insights

Written by Andrew Collins
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

SQL basics video series

Watch videos explaining querying in Benchling Insights

Written by Sanjay Saraf
Updated over a week ago

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