I am currently trying to make usefull widigtes exactly for our needs.

The standard widgets on the helpdesk dashboards are clickable so that you can pull out the list of affected tickets.

How do i make reports myself that can do htat?