How can I display Individuals with same procedure ID in different events in CJA | Community
Skip to main content
D
Deepak_Kv
Level 2
February 20, 2024
Question

How can I display Individuals with same procedure ID in different events in CJA

  • February 20, 2024
  • 1 reply
  • 1082 views

Hi community,

I have one event dataset with three fields: Event ID, Individual ID, and Procedure ID. The Event ID will be unique to all events, the Individual ID will be unique to each individual, and the Procedure ID can be the same or different in each event. I want to identify individuals who have had at least two events with the same procedure code in the last month. Is this possible in Customer Journey Analytics? If yes, how can I achieve this? Could you please explain step by step?

sample data 

event IDProcedure codeindividual ID
101PC111
102PC111
103PC212
104PC313
105PC413

 



output required :

individual ID
11
11

let me know if there is any questions.

Thanks in advance.

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    1 reply

    narendragandhi
    Community Advisor
    narendragandhiCommunity Advisor
    Community Advisor
    February 22, 2024

    Hi @deepak_kv 

     

    Apologies if I misunderstood the request but you can also use the query service within Adobe Experience Platform for this request - https://experienceleague.adobe.com/docs/experience-platform/query/ui/overview.html?lang=en. 

     

    Thanks

    Narendra

      D
      Deepak_KvAuthor
      Level 2
      February 22, 2024

      Hi @narendragandhi , we can do this query service. 

       

      But requirement is create dashboard in CJA and need to share it with stakeholders. Let me know if there is any way to do in CJA end.

      NimashaJain
      Adobe Employee
      NimashaJainAdobe Employee
      Adobe Employee
      March 15, 2024

      @deepak_kv Did you find the suggested solutions helpful? It would be great if you can  mark the answer as correct for posterity. If you have found out solution yourself, share it with wider audience in the community.

      Terms & ConditionsAccessibility statement

      Loading footer...