Insights [Enterprise]

Using Block Templates in Insights

Add tables and charts to Insights dashboards without writing SQL

Written by Rebecca Conway
Updated this week

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

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