Create report by combining 2 reports
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-24-2022 01:54 PM
Hello All,
We have a requirement to create a report (widget) for a dashboard where a client wants:
1. Total number of Incidents by caller > department.
2. Total number of Requested Items (RITM) by requested for > department.
Example:
- Sam from Accounting has 5 INC's and 5 RITM's
- Jack from Accounting has 10 INC's and 10 RITM's
- Berry from Sales has 20 INC's and 10 RITM's
Report should show:
- Accouting == Sam == 10
- Accounting == Jack == 20
- Sales == Berry == 30
I am able to achieve this but on 2 different reports by creating reports on INC and RITM table.
I have tried looking at multiple threads before posting this but no solution seems to have been working for me.
Any help is truly appreciated.
Thank you,
Manthan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-24-2022 01:58 PM
Hello You can do this by reporting off the TASK table- then you can filter/sort/group by TASK TYPE field which will show what table the task is coming from.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-26-2022 02:43 PM
Hello
Thanks for replying to the thread.
I have tried creating reports from Task table, but that has not helped.
Because as per our client's requirements we need to have a report that shows all INC's and RITM's in one bar. (See ss attached)
So if I have 10 INC's and 10 RITM's assigned to me the graph should show Manthan == 20.
Let me know if you want me to elaborate.
Thank you
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-26-2022 02:42 PM
Hello @bammar,
Thanks for replying to the thread.
I have tried creating reports from Task table, but that has not helped.
Because as per our client's requirements we need to have a report that shows all INC's and RITM's in one bar. (See ss attached)
So if I have 10 INC's and 10 RITM's assigned to me the graph should show Manthan == 20.
Let me know if you want me to elaborate.
Thank you