SUM + D_COUNT in the same query not working.
Hi All,
I'm hoping someone may be able to provide some advice on how to resolve the below issue I have..
We have custom numeric fields that we add to provide reporting on the number of activities or tasks our agents are completing within each ticket. There are a few categories (custom checkboxes) where there is a one to one relationship so the numeric field does not exist for these ticket types.
I have setup custom metrics to SUM the numeric fields and D_COUNT the checkboxes where there is no numeric field but just a checkbox.
Both these metrics appear to work correctly if I add only D_COUNT or only SUM metrics to my query but as soon as I add both my SUM and D_COUNT metrics in a single query the SUM metric results change and are wrong....
Nothing has been changed between the two screenshots below except that in the second one "MDUM Checks (Tasks)" has been added to the query.
Thanks
Melanie
-
Melanie
Can you confirm that for each of your custom metrics, the 'compute separately' option is checked?
-
Thank you Graeme! That fixed it.
-
Hi Graeme,
Thanks again for the assistance. The query now works for the individual metrics, but not when I try to add them together to get a total activity count. Any ideas on how this could be resolved?
((D_COUNT(MDUM Checks (Tasks))+D_COUNT(TEM: Bill Available (Tasks))+
SUM(TEM: Username Updates (Tasks))+SUM(TEM: Cost Centre Updates (Tasks))+
D_COUNT(TEM: Report Available (Tasks))+SUM(TEM: Report Requests (Tasks))+
SUM(TEM: Hierarchy Updates (Tasks))))Thanks
Melanie
-
Melanie
Glad we are getting there.
The best way to combine custom metrics is to go to Result Manipulation>Result Metric Calculation.
In there, you can add together your custom metrics to get a total.
Let me know how you get on.
-
Hi Graeme,
Thanks again, this worked by creating a new 2 new metrics. "Tasks - SUM" with my 70ish sum metrics, and "Tasks - DCOUNT" containing the 4 DCOUNT metrics then adding them together in Result Manipulation.
I'm a little concerned the result is incorrect as I'm getting an error that my query contains more than 50,000 rows.
I get this error on almost every query I try to create and the results are not the same as what's appearing in Insights, sometimes it's out by a few tickets but other times it's out by a lot or I'm getting blanks when I should be getting results.
-
Melanie
You may want to have a look at this Explore Early Access Program - Improved Performance for Large Queries.
It allows you to export queries with more that 50,000 rows, but for now there is still a limit in the query builder.
Hope that helps.
-
Thanks Graeme I have filled in the form, fingers crossed - appreciate all your assistance.
Iniciar sesión para dejar un comentario.
7 Comentarios