Forum Discussion

saud968's avatar
saud968
Icon for Memorable Member rankMemorable Member
5 years ago
Solved

TOP N filter by Top 3

I am trying to filter the top 3 PCM Names by an average CSAT score, however, it shows all the PCM listed. The average top 3 should be 3.9 and above. Needs assistance please help and apologize if I have missed on rules for the forum.

 

There is two different first one below is CSAT and the other is Closure

 

 

Full NameCase NumberResponded Date
(America/Cancun)		Closed Date
(America/Cancun)		CSATCESCommentsPCMProduct
Aleksandar Adamovic1542477/1/2021 1:30 AM7/1/2021 1:29 AM55 Saud AnsariFortify
Ashwin Adithiya1210321/30/2021 4:08 AM1/22/2021 5:33 PM55 Salman PatelPortal
Ashwin Adithiya1213712/2/2021 4:04 PM1/26/2021 4:01 PM33The feature is not available right now in the portalSalman KhanSecurity - Software
Aaron Falzon1207901/31/2021 4:41 PM1/31/2021 2:08 AM44While the Partner care team were very good at opening a line of communication, we still feel that the NOC are often letting us down.Ronak WaghelaPortal
Aashir Shaikh1353284/30/2021 10:56 AM4/28/2021 2:03 AM55 Saud AnsariHD Service
Aashir Shaikh1548036/30/2021 12:58 PM6/30/2021 12:56 PM55 Salman KhanControl
Alyssa Bly1624118/3/2021 11:09 AM7/30/2021 8:16 PM55 Ronak WaghelaAssist Help Desk
Peter Jobst1235902/18/2021 4:14 PM2/10/2021 5:15 PM11I doubt there is anything connectwise can do to stop sucking. We really HATE that we have to deal with Connectwise as a ContinuumSalman PatelPortal
Donna Grafing1349734/26/2021 4:03 PM4/26/2021 1:51 PM55 Salman PatelPortal
Wendi Yadauga1566447/20/2021 4:22 PM7/13/2021 3:54 PM33 Ronak WaghelaPortal
Accounting Department1361685/5/2021 9:51 AM5/4/2021 4:57 PM44N/A - I was the last person to be assigned this. I'm sorry I cannot provide further feedback. I appreciate your support while looking into this case.Salman KhanNot Product Related
Dawn .1429586/7/2021 6:23 AM6/5/2021 6:52 AM55 Ricky ThakurFortify
Dawn .1386266/7/2021 5:46 AM5/26/2021 3:00 PM55 Ricky ThakurFortify
Onsite Helper1218422/7/2021 3:12 PM1/29/2021 5:01 PM22please call us to validate if we are indeed aware of overdue account first. due to your upgrades and system changes, our auto pay setup was disregarded and we would normally check auto pay accounts.Sagar MorePortal
Adam Collis1557217/10/2021 7:26 AM7/10/2021 6:06 AM23When agreeing a future action, some sort of date for when it will be done should be agreed.  In this instance it was especially important as the issue has been left unresolved for many months.  Some form of commitment is required or even conformation nothing will be done.Rajeshkumar PatwaControl

 

Case NumberLegacy Case NumberEdited ByCategoryInquiry/Problem/RequestProduct (CWS)StakeholderAgeClosed DateEdit DateField / EventNew ValueCase TypeEventCase OwnerStatusPCM
164117 Rajeshkumar PatwaService Delivery Complaint - SLO/ASA not met, ticket delaysProblemAssist Help DeskHelpDesk3###8/9/2021, 7:01 AMStatusClosedPartner FacingNot ApplicableSaud AnsariClosed#N/A
164251 Rajeshkumar PatwaService Delivery Complaint - SLO/ASA not met, ticket delaysProblemAssist Help DeskHelpDesk3###8/9/2021, 7:14 AMStatusClosedPartner FacingNot ApplicablePartner Care Case QueueClosed#N/A
164081 Rajeshkumar PatwaBillingInquiryPortalPartner Care4###8/9/2021, 8:13 AMStatusClosedPartner FacingNot ApplicableRonak WaghelaClosed#N/A
163673 Rajeshkumar PatwaService DeliveryInquiryCommand - ServerNOC - Tech Advantage5###8/9/2021, 8:56 AMStatusClosedPartner FacingNot ApplicablePartner Care Case QueueClosed#N/A
164319 Ricky ThakurBilling - invoice errors or confusionProblemNot Product RelatedAccounts Receivable0###8/9/2021, 9:46 AMStatusClosedPartner FacingNot ApplicableRonak WaghelaClosed#N/A
164303 Ronak WaghelaProduct FunctionalityInquiryCommand - ServerNOC - SRT0###8/9/2021, 2:07 AMStatusClosedPartner FacingNot ApplicablePartner Care Case QueueClosed#N/A
164320 Ronak WaghelaProduct Errors - Software bugs, product performance, product down timeProblemPortalNOC - PST0###8/9/2021, 5:00 AMStatusClosedPartner FacingNot ApplicablePartner Care Case QueueClosed#N/A
164314 Ronak WaghelaService Delivery Complaint - Partner does not like existing scope/polices/proceduresProblemCommand - ServerNOC - SRT0###8/9/2021, 6:06 AMStatusClosedPartner FacingNot ApplicablePartner Care Case QueueClosed#N/A
164133 Ronak WaghelaService DeliveryInquiryCommand - ServerNOC - SRT3###8/9/2021, 8:46 AMStatusClosedPartner FacingNot ApplicablePartner Care Case QueueClosed#N/A
Need Help
Show and Tell
Tutorial Requests
  • ChrisMendoza's avatar
    ChrisMendoza
    5 years ago

    There is something wrong with the table formatting you've provided.

    I did however attempt to solve.

    Average CSAT = AVERAGE(Table1[CSAT])
    Rank PCM Simple =
IF (
    HASONEVALUE ( Table1[PCM] ),
    RANKX ( ALL ( Table1[PCM] ), [Average CSAT] )
)

    Top 3 PCM = 
IF(
    HASONEVALUE(Table1[PCM]),
    IF(
        [Rank PCM Simple] <= 3,
        [Average CSAT]
    )
)

     

4 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    5 years ago

    Hi,

    This pattern should work

    Average CSAT score = average(data[csat])

    Top 3 = calculate([Average CSAT score],topn(3,all(data[PCM]),[Average CSAT score])),values(data[PCM]))

    To your visual, drag the second measure.

    Hope this helps.

      • ChrisMendoza's avatar
        ChrisMendoza
        Icon for Resident Rockstar rankResident Rockstar
        5 years ago

        There is something wrong with the table formatting you've provided.

        I did however attempt to solve.

        Average CSAT = AVERAGE(Table1[CSAT])
        Rank PCM Simple =
IF (
    HASONEVALUE ( Table1[PCM] ),
    RANKX ( ALL ( Table1[PCM] ), [Average CSAT] )
)

        Top 3 PCM = 
IF(
    HASONEVALUE(Table1[PCM]),
    IF(
        [Rank PCM Simple] <= 3,
        [Average CSAT]
    )
)