Issue Summary

Using the concat function returns in visual step returns the following error: 
 
[SQLITE_ERROR] SQL error or missing database (no such function: concat)

Steps to Reproduce

1. create a chart and select two columns you'd like to combine
2. Run the query
3. Create a custom formula and type in concat(column1, column2)
4. it returns the error: [SQLITE_ERROR] SQL error or missing database (no such function: concat)

Expected Results

The function was previously recognised and has been used in charts. The function should work.

Actual Results

Using the concat function returns the following error

[SQLITE_ERROR] SQL error or missing database (no such function: concat) 

Workaround

Use the || operator. Follow our community post here