Hi. I'm trying to make a table visualization where business accounts are the rows, custom field (labeled default fields in the screen recording) names are the column headers, and the values are the actual string values for the custom field on each account. As you can see in the screen recording, when I drag in the value attribute it switches it to the count of the value rather than the text of the value. How can I make it show the text for the value? The way the model is set up, it could technically have more than one value since it is a one to many relationship between the accounts table and the default field values table (i.e. custom field values). However, in practice there will only ever be one default field value record per default field (i.e. custom field). Thanks.

Hi Adam, The reason a count is being applied to your attribute is that you’re dragging it into the metric section, which automatically performs an aggregation function. Instead, try dragging and dropping it into the column section. Would that work for you?

@Julius Kos Dragging and dropping the default field value name into the columns section just puts all possible values in the column header and nothing in the middle of the table, which is not what we need (see first attached screen recording -- ignore the title). The values need to be in the middle and the names need to be in the column header so we know what values correspond to what name. The first screen recording I sent shows this except with the count instead of the text value in the middle of the table. How can this be achieved? Maybe there is a way to override the aggregation function? Or maybe there is some other approach I am not aware of? For example, I attached a second screen recording (again ignore the title) of an alternative approach that successfully shows one default field name in the column header and corresponding default field values in the rows, but it only works for one default field name and I cannot see how it could be expanded to show all default field names in a single table.

I don't believe you are going to be able to achieve what you are looking for creating the table in this manner. You can, however, try utilizing a custom visualization

That’s too bad. Seems like a simple case that you should be able to handle. As for custom visualizations, if I am reading it right, we would need to use JavaScript to display the data as the last step. But then how would we show it in a good data dashboard or something that is embedded in our app via iframe? Are there any examples or tutorials that show these from start to finish?

this can be done through web components: https://www.gooddata.com/docs/gooddata-ui/latest/learn/embed_dashboards/web_components/

Good to know, however we must use iframe instead of web components because web components do not allow the edit dashboard/visualization stuff.

🎉 New note created.