Joining Similar data to create summarised view

Joining Similar data to create summarised view

Hi All,

I have two separate data sets I am loading to an application in Zoho Creator. They have alot of the same fields an some different but ultimately I'd like to be able to run reports on the fields that are the same to pull together a summary view. 

The data is like this:

Email
 ID Root Cause Inquiry Cycle Time Satisfaction






Phone
 ID Root Cause Inquiry AHT ACW







With 'Root Cause' and 'Inquiry' being the same, I'd like to be able to generate a report that's shows the total volumes for each of the tables already residing in Zoho. Is this possible?

More data will be added to these tables each month so ideally would like to be able to then refresh accordingly.

Any guiedace would be most appreciated.

Thanks,

Brent


      • Topic Participants

      • brent

      • Sticky Posts

      • How to Add Users to your Organization in ZohoMail?

        A better clarity so you can create other users to start using Zoho Mail. You can directly Add Users from the Control Panel to your Organization. You can invite users with the existing email address. If the person (user) already uses ZohoCRM, then you can import users from Zoho CRM. You can also import them using a .csv file. (if you are planning to add them in Bulk)  In this topic, We will be discussing on how to Add and Invite users only.  The Import options are self explanatory. ____________________________________________________________________________________________________________