Reporting and Analytics for Service

Get Involved. Join the Conversation.

Topic

    Pavol Procka
    Incidents with attachments showing multiple times.Answered
    Topic posted June 28, 2017 by Pavol ProckaSilver Crown: 22,500+ Points 
    162 Views, 1 Comment
    Title:
    Incidents with attachments showing multiple times.
    Content:

    Hi,

     

    I have a report that shows all Incidents in all Qs.

    What I I am adding is the paperclip icon that is displayed next to the incidents that contain attachments.

    I managed to get the paperclip icon in and even managed to get the total number (on the top level) to exclude the duplicates in the count, but the final level of the report now shows incidents that have more than 1 attachment multiple times (i.e incident with 3 attachments is showing 3 times).

    Any ideas how to make it so that every incident ID is only displayed one time in the final level?

    Attached is my report definition.

    Many thanks

    Pavol

    Document:

    Best Comment

    Pavol Procka

    I got it now.



    All I had to do was to adding a count column of the incidents.i_id field and then hide it.



    Found the info in the following topic: https://cloudcustomerconnect.oracle.com/posts/b84f8204ab - thanks to  Danette Beal



    If anyone is interested to use this one, I am adding the report definition of the final product :)



    Many thanks



    Pavol

    Comment