Insights: Add related columns to selection list for axes

[DustinBracy]

Summary

First I want to say that I love the new insight modules!

However, creating a new plot only shows the ID for relationship fields in a collection. This is a problem for fairly normalized databases, where many tables have foreign key relationships (all of them, in fact, if you want to use the 'user_created' field). The labels end up being represented entirely of UUIDs, which are not very user friendly.

The ability to select related column names, or even respect the default display template configured on the collection relationship field would go a very long way into making plots more usable.

Basic Example

No response

Motivation

Bar and Line Charts are almost unusable on collections using relationships. The below chart doesn't provide any business insight without manually looking up each UUID.

Showing the user names (first/last), instead of the user ID here would be infinitely more helpful to anyone looking at the chart.

Detailed Design

Add related fields with dropdown in the X/Y axis selection boxes, similar to how we have in the column add section of the collection table interface.

Current Panel X/Y Axis Selection:

Desired Panel X/Y Axis Selection:

Requirements List

Must Have:

• The ability to select other columns from the foreign table in as axis labels.

Could Have:

• The ability to modify the display template of the plot labels for each axis.
• The ability to control sort by fields other than the display axis.

Drawbacks

• It requires additional code to pull in related fields.
• Possibly impacts plot performance with deeply nested relationships.

Alternatives

Create plots in an outside application.

Adoption Strategy

No breaking changes, this would simply be an additional swatch of fields to choose from for label purposes.

Unresolved Questions

No response

[emahuni]

When I saw this limitation I thought I was missing something somehow. But it seems like it's a real thing.

[ImAnAutie]

Same here, it feels like im missing something obvious!

[LevelUpGit]

+1 It's really required, data has no sense without it.

[gloribus]

++++1

It would also be cool if it would support displaying text not values if the field is a dropdown

[Seinnd]

👍

[rijkvanzanten]

Heya! Thanks for opening this feature request!

This feature request has received over 15 votes from the community. This means we'll move this feature request to the Under Review state!

The Core team will schedule a meeting to review this request as soon as possible. The discussion will then be approved or denied. You may or may not be invited to join this meeting with the core team.

For more information, see our Feature Request Process.

[fredjoz]

++++1
this function is really missing

[photographycoursenet]

+1 for this

[devMls]

+1 for this

[xhulianobushi]

+1 for this

[floux-digital]

Some news about it?

+1,000 for this.... and, I miss the possibility of adding a global date filter (from / to) to control the dashboard more easily.

[gla23]

Yep agree this feels pretty essential when first trying out the graphs!

It would be great if there was a sensible default. For example instead of using a UUID or integer primary key, use a likely related field e.g. in my case that would be matching for a field ending with _name? (This would never be perfect but a quick guess is better than nothing?)

From playing around previously I got the impression this is done elsewhere for default Display Templates but I can't remember exactly where.