Insights

Help articles for the Insights tool.

Hannah Park avatar Andrew Collins avatar Anshi Saxena avatar +1
23 articles in this collection
Written by Hannah Park, Andrew Collins, Anshi Saxena and 1 other
FAQ

How do I convert row_index and column_index to well positions?

Well and Box Positions
Namitha Patil avatar
Written by Namitha Patil
Updated over a week ago

How do I join data from different Benchling Applications?

Key Joins for Applications in Benchling
Namitha Patil avatar
Written by Namitha Patil
Updated over a week ago

How do I aggregate data across different organizations?

Combine data across Benchling organizations
Hannah Park avatar
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
Anshi Saxena avatar
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
Anshi Saxena avatar
Written by Anshi Saxena
Updated over a week ago

How do I add timezones to my Datetime values?

Adjust Timezone for Datetime columns
Anshi Saxena avatar
Written by Anshi Saxena
Updated over a week ago

How come my division yields wrong numbers?

Specify precision on number columns
Anshi Saxena avatar
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
Hannah Park avatar
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
Hannah Park avatar
Written by Hannah Park
Updated over a week ago

How is “PARTITION BY” different from “GROUP BY”?

Window Functions vs. Group By
Hannah Park avatar
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
Anshi Saxena avatar
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
Hannah Park avatar
Written by Hannah Park
Updated over a week ago

How do I search for multiple values in a parameter?

Filter data on multiple values
Anshi Saxena avatar
Written by Anshi Saxena
Updated over a week ago

How do I set up partial text matching for Parameters?

Use CONCAT and LIKE/ILIKE
Hannah Park avatar
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
Hannah Park avatar
Written by Hannah Park
Updated over a week ago