How to include custom queries in Dashboard template in RTC
One answer
To add a custom report to the dashboard widget, you can follow the technote http://www-01.ibm.com/support/docview.wss?uid=swg21454548
If you'd like to add the widget as a dashboard template, you can follow the same steps but add the viewlet from "Dashboard Template" refer to https://jazz.net/help-dev/clm/index.jsp?topic=%2Fcom.ibm.jazz.dashboard.doc%2Ftopics%2Ft_config_dashboard_templates.html.
To add a custom query, the process is same as the above. The difference is for Identifier you need to select "Work Item" (com.ibm.team.workitem.viewlet.queryresults) and input the custom query id in "Default Query" of the Preferences tab.