I am struggling with the report which will show the list and number of tickets per Channel Name. The thing is that on the list of tickets from the Workcenter view 'Source' and 'Channel' fields are showing the very first interaction of the ticket which is required by us from reporting perspective.
Unfortunately, the standard Data Source 'All Tickets with All Interactions' is showing all the interactions, not only this very first.
The challenge is to get the right results - let me show you an example from above screenshot. When we will look at this ticket from report perspective we have different kind of interactions in the column 'Channel Name' (# means here that this is Manual entry interaction):
Here I have two problems:
1. Suppose I want to display tickets where 'Automation.Support...' (with dot between these two words) is the very first interaction. That's ok - when I will set the selection for this Channel Name this ticket will be included. BUT when I will set the selection for Channel Name 'AutomationSupport...' this ticket will be also included, which is a wrong result, because filter logic in C4C (according to my knowledge) works that it will find every object where the set filter exists.
2. I tried to set the conditions to display only first row from this report view, but also without luck.
I am doing my best, but I really don't have any other ideas how to achieve the results in report which can be easily achieved from the list of tickets from workcenter view. This is really strange that this data source do not predict such scenario where business wants to filter by channel names from the very first interaction perspective.
Any suggestions or ideas from your side are highly welcome. Thank you in advance!
Since these are 2 distinct channels, its strange that its not returning records specific to that channel only. Can you paste a screenshot of all the selection screen showing all the fields that you are using to run the report? specifically can you paste the selection criteria for the channel?
Quick question. Is Automation.Support and AutomationSupport the same channel or are they different channels?
Can you paste a screenshot of the email addresses config. like the one below. Please mask anything that is private/ confidential. 🙂
And just to clarify your question 1, when you search for AutomationSupport (without the dot) you do not want the one with the dot to show. Is that correct?
To clarify question 2, you want to only show the first record in the report, similar to what you see in the Tickets OWL. Is that correct?