Forum Discussion

mrhenderson's avatar
mrhenderson
Frequent Visitor
1 year ago

Creating a First Call Resolution measure

Hello,   I am trying to create a measure that show first call resolution for within 7 days. Essentially, i have a table that liosts all phone calls taken by every CSR. There is a have a column that...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
1 year ago

Hi,

Share data in a format that can be pasted in an MS Excel file.  Show the expected result there.

  • mrhenderson's avatar
    mrhenderson
    Frequent Visitor
    1 year ago

    Table: FLODS_INTERACTION _F00

    CREATED_DTCREATED_BY_IDINTERACTION_ID
    1/2/2024jessica.smith1.01001E+11
    1/2/2024jessica.smith1.01001E+11
    1/2/2024billy.jones1.01001E+11
    1/2/2024billy.jones1.01001E+11
    1/2/2024billy.jones1.01001E+11
    1/2/2024billy.jones1.01001E+11
    1/3/2024jessica.smith1.01001E+11
    1/3/2024jessica.smith1.01001E+11
    1/3/2024jessica.smith1.01001E+11
    1/3/2024jessica.smith1.01001E+11
    1/3/2024jessica.smith1.01001E+11
    1/3/2024jessica.smith1.01001E+11
    1/3/2024jessica.smith1.01001E+11
    1/3/2024jessica.smith1.01001E+11
    1/3/2024jessica.smith1.01001E+11
    1/3/2024jessica.smith1.01001E+11
    1/4/2024john.smith1.01001E+11
    1/4/2024john.smith1.01001E+11
    1/4/2024john.smith1.01001E+11
    1/4/2024john.smith1.01001E+11
    1/4/2024john.smith1.01001E+11
    1/4/2024jessica.smith1.01001E+11
    1/4/2024jessica.smith1.01001E+11
    1/4/2024jessica.smith1.01001E+11
    1/4/2024jessica.smith1.01001E+11
    1/4/2024jessica.smith1.01001E+11

     

    table FLODS_ENQUIRY_INT_RELATIONSHIP_F00

    INTERACTION_IDobject/party/classification
    101001026174.001.01001E+20
    101001026178.001.01001E+20
    101001026180.001.01001E+20
    101001026181.001.01E+20
    101001026185.001.01001E+20
    101001026186.001.01E+20
    101001026187.001.01001E+20
    101001026192.00'-99101000328
    101001026193.001.01E+20
    101001026194.001.01001E+20
    101001026195.001.01E+20
    101001026196.001.01001E+20
    101001026199.001.01001E+20
    101001026201.001.01001E+20
    101001026202.001.01E+20
    101001026204.001.01001E+20
    101001026206.001.01001E+20
    101001026207.001.01E+20
    101001026209.001.01001E+20
    101001026210.001.01001E+20
    101001026211.001.01001E+20
    101001026212.001.01001E+20
    101001026213.001.01E+20
    101001026214.001.01001E+20
    101001026216.001.01001E+20
    101001026218.001.01001E+20
    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      1 year ago

      Hi,

      Based on the 2 tables that you have shared, show the expected result very clearly.