We are using reports to export data for our product and have come acress a need to use text_agg() in one of the columns to stop duplicate rows. This good (we need the aggregated data) but it would be nice to extend this to supprt a delimeter type like we have in Join(text field, delimiter) which is not available in Reports. As ware exporting a CSV it would be nice to be able to for example use | as our delimter in these columns. I know I can make a new field in the DB and use that which I will do for now but thought I’d post this anyway.
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Is there a 'join' function in the reports? | 3 | 51 | October 14, 2024 | |
| Can't export rich text fields from table view | 14 | 1067 | February 2, 2022 | |
| CHANGELOG: September 24 / Some new formulas and some fixed bugs | 0 | 762 | September 24, 2020 | |
| [DONE] Column Calculations in Table view | 16 | 1509 | September 19, 2024 | |
| Calculate lookups on the front end (based on filters) | 5 | 46 | February 13, 2025 |