Unable to modify widget view

Problem/Motivation

I am trying to modify the widget view to show more info about the notification.
I need to show fields from the user profile (profile module) and node fields.

For example "User XXX published a node "node title" "node body" 1 hour ago.

When I add relationships; Event (user), (Users) Profile, (user)Flags for displaying notifications about
new nodes from users which the current user follows.
I am not able to create the view so that It would show anything sensible.
The notifications are just displayed twice, even distinct is selected.

How should the view be created?

There is the "reference" field which is either /node/node_ID or /comment/comment_ID
Is there just plain ID field of the node or the comment?

I guess the only way to show anything else related to notifications is "views field view" which
is (I think) a bad solution in terms of performance.

So what I need is more flexible widget to be able to create social media like site notifications.

Let me know if Danse is not the correct solution for this kind of feature, is danse mainly
made for displaying logs?

What I need is as efficient and fast notifications system for the end users, not for the admins.

Steps to reproduce

Proposed resolution

Remaining tasks

User interface changes

API changes

Data model changes