I'm relatively new to GoodData, and have been creating some reports/dashboards in Kantata Insights. I have a need for a report that shows Project Name, Task Name, Task Assignment: Resource Name, Task Due Date. I would like to see one row per Project, and then aggregate the Task Assignment: Resource Names, delimited by commas. This would be pretty straightforward in SQL, but I'm having trouble figuring out a way to do this with MAQL. Does anyone know if this is possible?

Hi Brent, happy to help. First I would need more details of the LDM, are they in the same datasource? Then.. the Insight I assume should be a table. Do you have for example a 'Project ID'? Also, we can not 'add' commas. It would be nice if you can create an example of what you want to achieve.

Project and task and task assignment are separate tables in the DB. In this particular report, I'm only looking at one task per project, but each task may have multiple Task Assignment: Resource Names (the name of the person assigned to the task). So in the current Insights report it looks like this: Row 1: Project Name: Project A Task Name: Task A Task Assignment: Resource Name: John Doe Task Due Date: 4/1/2025 Row 2: Project Name: Project A Task Name: Task A Task Assignment: Resource Name: Sam Smith Task Due Date: 4/1/2025 But I need the results to look like this: Row 1: Project Name: Project A Task Name: Task A Task Assignment: Resource Name: John Doe, Sam Smith Task Due Date: 4/1/2025

Im sorry, but currently this is not supported in GoodData

Hi @Brent, this may be possible to achieve using UI SDK and creating a Custom Visualization

Hi Brent I am wondering if you had the chance to see the provided documentation by my colleague.

Hi @Mauricio Cabezas unfortunately I wasn't able to get this to work within the tool. I ended up exporting to Excel and using a formula there to aggregate the fields.