Grow has the ability to use SQLite to transform data that comes in from any data source.

Let's say for example you get back a long list of issues from Jira that include all the columns and fields but you only want the key and the description. You could use the Remove Columns button or you could do it in SQL.

More common is using a Where clause to select only certain rows of data.

To use SQLite on your data, just click into the SQL box, enter your query and click 'Connect'. You reference the data as 'report'.

Here is a list of common SQLite Queries

Here is a list of common SQLite errors and the fix.

Here is how to divide columns using SQLite

If you have any questions please email or chat in on the site.

Did this answer your question?