Forum Discussion
Category Comparison Graph
Hey Everyone, I would like to compare our categories of Call Intent Types by day, looking at one particular category’s calls versus the total calls. I would also like to do this comparison by Di...
Hi JCovelli,
If it is convenient, could you share some data sample and your desired output so that we could help further on it?
Best Regards,
Cherry
Hello!
Yes I prepared an excel file with fake data, however I cannot see how to upload it here. Am I missing that?
John
So, I have just now discovered the "New Quick Measure" feature and created a line graph that shows the performance by date of one category AND the total of all categories- two lines....
If I could CONVERT this to show the % To Total- ONE LINE-, then I could do the Divisional analysis... I think I am getting closer!
Number Of calls By date Category 1/1/2018 1/2/2018 1/3/2018 1/4/2018 1/5/2018 1/6/2018 1/7/2018 1/8/2018 1/9/2018 1/10/2018 Claims 1237 1021 398 570 995 22595 20922 20225 Division One 247 204 80 114 199 0 0 4519 4184 4045 Division Two 433 357 139 200 348 0 0 7908 7323 7079 Division Three 557 459 179 257 448 0 0 10168 9415 9101 Billing 2633 2313 1053 1541 1776 2473 2460 2458 Division One 527 463 211 308 355 0 0 495 492 492 Division Two 922 810 369 539 622 0 0 866 861 860 Division Three 1185 1041 474 693 799 0 0 1113 1107 1106 Complaints 2722 2495 1738 1984 166 72 2490 2021 1986 Division One 544 499 0 348 397 33 14 498 404 397 Division Two 953 873 0 608 694 58 25 872 707 695 Division Three 1225 1123 0 782 893 75 32 1121 909 894 Address Change 2163 1521 2597 1237 1021 398 1541 Division One 433 304 0 0 519 247 204 80 0 308 Division Two 757 532 0 0 909 433 357 139 0 539 Division Three 973 684 0 0 1169 557 459 179 0 693 Total Call Intents 15347 13179 2902 7698 12107 1569 1165 55514 50806 50879 Division One 3069 2636 580 1540 2421 314 233 11103 10161 10176 Division Two 5371 4613 1016 2694 4237 549 408 19430 17782 17808 Division Three 6906 5931 1306 3464 5448 706 524 24981 22863 22896
