SUM + D_COUNT in the same query not working.

7 Comments

  • Graeme Carmichael
    Community Moderator

    Melanie

    Can you confirm that for each of your custom metrics, the 'compute separately' option is checked?

    0
  • Melanie

    Thank you Graeme! That fixed it.

    0
  • Melanie

    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

    0
  • Graeme Carmichael
    Community Moderator

    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.

    0
  • Melanie

    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.

     

     

    0
  • Graeme Carmichael
    Community Moderator

    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.

    0
  • Melanie

    Thanks Graeme I have filled in the form, fingers crossed - appreciate all your assistance.

    0

Please sign in to leave a comment.

Powered by Zendesk