Jump to content

Source Type Email


Shamaila.Yousaf
 Share

Recommended Posts

I would like to create a widget to see which departments are logging the most calls via email so I can look into targeting these areas to promote / increase the Customer Service Portal.

Any ideas if this would be a possibility and how I would look into arranging?

 

Your assistance is greatly appreciated as always.

 

Regards

Link to comment
Share on other sites

Hi @shamaila.yousaf

Departments are a little tricky to do in Analytics as the tables are stored separately. How many departments do you have? 
If its not too many, one way could be creating a different widget per department, each with a count. 

 

Screenshot_2.png

 

Would this work or are you looking for something different? I achieve the above using the following:

Screenshot_3.png

 

The WHERE clause is a bit of a combination of a few of the things we have gone through over the past few days - please see the green underlined part, this is the ID of the department you are measure. 
The text to copy is:

 

h_fk_user_id IN(SELECT h_user_id from h_sys_account_groups where h_group_id = 'Ares/Finance/')
AND
h_source_type = 'Email'
AND
h_datelogged >=  MAKEDATE(YEAR(NOW()),1)

 

Kind Regards

Bob

 

Switch On Workload.xlsx

Link to comment
Share on other sites

Thanks again @Bob Dickinson and apologies for the long delay in getting back to you. Cutting a long story short, I have been informed that this will be a 'no go' from our end as the departments are picked up from another system and they are not aligned as they should be. So work in progress.

 

I have this to refer back to should the need be required.

 

Regards

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...