Show Entity name for relations when visualizing as anything but raw table

Get Help
1

Hi,

I don't know if this is a bug, missing feature or misconfiguration (I am hoping on the latter...).

So I have a table called "History" that show history notes saved in the database (this is a CRM database). The history notes are connected to a "Company", which is a different table in the database.

lime%20bi%201
lime%20bi%2011890Ă—949 127 KB

When showing the raw history table, the company relation shows the entity name, which is great. But when I try any visualization, grouping on "Company", it switches "Company" to the ID of the company instead.

lime%20bi%203
lime%20bi%203705Ă—613 19.4 KB
lime%20bi%204
lime%20bi%204775Ă—509 23.5 KB

The field "Company name" is set as "Entity name" as the screenshot shows:

lime%20bi%202
lime%20bi%2021189Ă—999 34.3 KB

I do know that I can select to group on for example "Company name" to get the desired result, but should that really be necessary in this case? This is just one example of many where I would like to show the Entity name in visualizations rather than "Entity key" (which it does now If I understand things correctly).

Thanks for your help!

2

Hi @mangefager
Please use support email, when using the Enterprise Edition.
I’m taking a guess that “Company” is actually just an ID with “Display values”=“Use foreign key” defined.
https://github.com/metabase/metabase/issues/5600

3

I thought it was of general interest, that’s why I am using the forum. But i’ll go through the support. Thanks for the quick answer.

4

@mangefager If you go through support, then we can track the issues and that makes a big difference in prioritization.

1 Like
5

I'm in need of the same information.

I wish to see the entity name instead of its id (or both)