Create report by combining 2 reports

[Manthan]

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

[bammar]

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. 

[Manthan]

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

[Manthan]

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