Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
callref | groupid | repid | udid | udindex | udtype | Updatetime | updatetxt | count(cust_name) |
---|---|---|---|---|---|---|---|---|
1 | ||||||||
195722 | SERVICE DESK | willmq | 1130675 | 0 | 3329 | 18/04/2013 | Logged From Inbound Email (Mailbox: Group Services I.T. Service Desk, | 1 |
195722 | IT SUPPORT | cookaz | 1130711 | 1 | 1 | 18/04/2013 | Call assigned to the IT SUPPORT group by cookaz (switched in group context) | 1 |
195722 | IT SUPPORT | aliaz | 1130729 | 2 | 1 | 18/04/2013 | Call was accepted by aliaz and the response time was acknowledged and achieved. | 1 |
195722 | IT SUPPORT | aliaz | 1130895 | 3 | 1 | 18/04/2013 | Hi Asif, Still can't get in after resetting my password to tipton123 on Samba which Colin did for me. See if yiu can try or will have to wait until Dave S is back in | 1 |
195722 | IT SUPPORT | aliaz | 1130896 | 4 | 514 | 18/04/2013 | The Username on samba whitcb.docx file has been added to the call by aliaz | 1 |
195722 | IT SUPPORT | aliaz | 1132721 | 5 | 1025 | 23/04/2013 | I have advised user to map the share by putting the following logon format Username: cyborg61\whitcb and then the password for that server which is now working fine, Chris to further action this call and have requested to pass this call to him. | 1 |
195722 | SERVICE DESK | willmq | 1132722 | 6 | 1 | 23/04/2013 | Call assigned to whitcb by willmq | 1 |
195722 | FINANCIAL SYSTEMS | whitcb | 1132867 | 7 | 1 | 23/04/2013 | Call accepted by whitcb | 1 |
195722 | FINANCIAL SYSTEMS | whitcb | 1132868 | 8 | 1 | 23/04/2013 | chris tested it works at Green Lane | 1 |
195722 | FINANCIAL SYSTEMS | whitcb | 1132869 | 9 | 1 | 23/04/2013 | have arranged for this to be made available for Chantelle next week. | 1 |
The above table is a copy of all the information that occurred on a specific call (call refL 195722). In the updatetxt field we have information that user has not input such as call accepted by, call assigned to etc. We need to create a chart that counts the call ref (in this case 1), and then enters into a Bar Chart the month in which the call was accepted or assigned. However as we the above call on the 18/04/2013 under udindex no2 the call was accepted, however it was then accepted again on 23/04/2013. If we were running the report on the 30/04/2013, we would like this to show that the call has been accepted. Is this possible?
Create a flag to find Call Assigned/Call Accepted then use this field in the bar chart
if(wildmatch(upper(updatetxt) ,'*CALL ASSIGNED*'),'Call Assigned',
if(wildmatch(upper(updatetxt) ,'*CALL ACCEPTED*'),'Call Accepted')) as Flag