<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">
On Oct 4, 2016, at 2:09 PM, Anthony Nguyen-Duong <<a href="mailto:anthnd@hotmail.com" class="">anthnd@hotmail.com</a>> wrote:<br class="">
<div>
<blockquote type="cite" class=""><br class="Apple-interchange-newline">
<div class="">
<div id="divtagdefaultwrapper" style="font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; font-size: 12pt; font-family: Calibri, Arial, Helvetica, sans-serif;" class="">
<div style="margin-top: 0px; margin-bottom: 0px;" class="">Hi Landon,</div>
<div style="margin-top: 0px; margin-bottom: 0px;" class=""><br class="">
</div>
<div style="margin-top: 0px; margin-bottom: 0px;" class="">Thanks for the reply.<span class="Apple-converted-space"> </span><br class="">
</div>
<div style="margin-top: 0px; margin-bottom: 0px;" class="">In your implementation, what kind of charts can you make with those CFs?</div>
</div>
</div>
</blockquote>
<div><br class="">
</div>
<div>We classify our tickets by subject matter so the chart I'm seeing is basically grouped by three CFs. It basically shows that X staff replies are made for every Y client replies broken down by each classification. It's not perfect but I haven't looked
into using the calculation part of the graphing yet for CFs.</div>
<br class="">
<blockquote type="cite" class="">
<div class="">
<div id="divtagdefaultwrapper" style="font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; font-size: 12pt; font-family: Calibri, Arial, Helvetica, sans-serif;" class="">
<div style="margin-top: 0px; margin-bottom: 0px;" class="">I have implemented a "Number of Emails" CF before with a similar implementation as your second approach, but when charting I can only use it for grouping. So the table would look something like:</div>
Number of Emails | Ticket count<br class="">
------------------------------------------------<br class="">
0 53<br class="">
1 89<br class="">
2 25<br class="">
Further, wouldn't all tickets that already exist in my database have "(no value)" for the new CF? My understanding is that the new CF would only "kick in" for new tickets.<br class="">
I might re-consider implementing a CF again, but something similar to your first approach. The second approach is definitely more efficient, but my supervisor has asked that I implement it in a way that it is drawing from the data in the database rather than
incrementing a counter, which could end up being less reliable.<br class="">
</div>
</div>
</blockquote>
<div><br class="">
</div>
</div>
I think I would consider doing some creative joins and subqueries with the mysql tables to get this information instead but it will get complicated really quickly. I should have mentioned that after I used the second approach I described I had to update all
the tickets with the first approach in order to get everything caught up but I only have to do it once after the second approach was finished and working.
<div class=""><br class="">
<div class="">
<div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">
<div style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: 18px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;">
--<br class="">
Landon Stewart<br class="">
Lead Analyst - Abuse and Security Management<br class="">
INTERNAP ®<br class="">
📧 <a href="mailto:lstewart@internap.com" class="">lstewart@internap.com</a><br class="">
🌍 <a href="http://www.internap.com" class="">www.internap.com</a></div>
</div>
</div>
<br class="">
</div>
</body>
</html>