Top 3 Reason Types

[manojkulkarni]

Hi Friends

Below is the table having case ID & Reason Type. We would require to calculate number occurrences of each reason type and show top 3 reasons as expected in the second table provided below.

Any suggestion or help is appreciated

Table1:

CaseID	Reason
449790	Q: Identify Payee
453917	Q: Vendor Refund
456423	Q: Identify Payee
456427	Q: Identify Payee
455388	Q: Identify Payee
455386	Q: Identify Payee
455361	Q: Advise on Allocation of Receipt
456900	Q: NonTenant check
453845	Q: Advise on Allocation of Receipt
456757	Q: Advise on Allocation of Receipt
456759	Q: Advise on Allocation of Receipt
456804	Q: Advise on Allocation of Receipt
456814	Q: Advise on Allocation of Receipt
456806	Q: Identify Payee
445595	Q: Advise on Allocation of Receipt
456783	Q: Advise on Allocation of Receipt
446283	Q: NonTenant check
453759	Q: Advise on Allocation of Receipt
455411	Q: Advise on Allocation of Receipt
456811	Q: Advise on Allocation of Receipt
456819	Q: Advise on Allocation of Receipt

Table2:

Reason	Occurance
Q: Advise on Allocation of Receipt	High
Q: Identify Payee	Medium
Q: NonTenant check	Low

[sunny_talwar]

Like this

[manojkulkarni]

Thanks for your immediate response. This is working.

What we are expecting here is , Occurrence will be my Label Heading & Highest count of cases of a reason should be displayed based on data in Text Object

[tresB]

Like this?

[manojkulkarni]

Thanks Tresesco for solution. How we should handle when we have same count for 2 different reason ?

example:

Table:

LOAD * INLINE [

    CaseID, Reason

    449790, Q: Identify Payee

    453917, Q: Identify Payee

    456423, Q: Identify Payee

    456427, Q: Identify Payee

    455388, Q: Identify Payee

    455386, Q: Identify Payee

    456900, Q: NonTenant check

    453845, Q: Advise on Allocation of Receipt

    456757, Q: Advise on Allocation of Receipt

    456759, Q: Advise on Allocation of Receipt

    456804, Q: Advise on Allocation of Receipt

    456814, Q: Advise on Allocation of Receipt

    456806, Q: Identify Payee

    445595, Q: Advise on Allocation of Receipt

    456783, Q: Advise on Allocation of Receipt

    446283, Q: NonTenant check

];

[sunny_talwar]

What would be the expected output? See both?

[sunny_talwar]

Something like attached

[sakthi266]

Hi Sunny Talwar,

       Expected Result is Like this

High : Q: Advise on Allocation of Receipt

Medium : Q: Identify Payee

Low   : Q: NonTenant check

Because , Q: Advise on Allocation of Receipt and Q: Identify Payee are 7 , By Alphabet It should show like this.

File Attached is showing given below

High : Q: Advise on Allocation of Receipt

Medium : Q: NonTenant check

Low : Null

[sunny_talwar]

Check attached