There are a few different visualization options available on the Benchling Insights application to graph your queried data. The current visualizations include Bar Charts, Line Graphs, and Scatter-Plot graphs.
One can configure the graphs by utilizing the buttons shown below:
Chart Type Dropdown - use this button to toggle what type of chart to be displayed from your data.
Table Setting Button - use this button to toggle displaying the axes parameters.
Axes Config - these buttons are used to set what columns to associate with your axes in your graph.
Bar charts rely on a categorical X-axis. They are routinely “Text” fields e.g. “Protein Family” or “Name” and not numerical.
The Y-axis is your numerical axes. You will want to choose like “count” or “result”.
Generally, you would specify the series axes with your different experimental groups (e.g. Cell Line A vs Cell Line B).
Once you select one of your tables’ column as the X or Y-axis, a visualization will show up.
Line graphs are useful for displaying a change in something over a continuous range. Setting up a line graph involves using a numerical X-axis, and a numerical Y-axis (e.g. time-series data).
Note: There is a 1000 row limit for the amount of rows one can load into the Insights tool.
You can also add a third layer of granularity by coloring the line based on experimental grouping such as “color” or “type.” (If you do not sort by series, the line chart will not discriminate between the your experimental groups).
The scatterplot is used to look at relationship or trend between two different, continuous variables. Its setup is very similar to the line chart.
The X and Y-axes both take in numerical values, and can be sorted by experimental groups based on the series button.
If a scatter plot has been selected, users will be given the option to add a linear regression to the plot. Once selected, the regression line will be overlaid on top of the chart, with the regression model and the R-squared value appearing on the top right of the plot.