Jump to content

Source Type Email


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.



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. 




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



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/')
h_source_type = 'Email'
h_datelogged >=  MAKEDATE(YEAR(NOW()),1)


Kind Regards



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.



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
  • Create New...