RightNow Communities Logo

RightNow Customer Forums

Register  ·  Sign In  ·  Help
Jump to Page:   1
  Reply   Reply  

Report for Top 100 customers that opened cases in a specified period   [ Edited ]
Options    Options  
JLFolkman
New Advisor
Posts: 48


JLFolkman

Message 1 of 6

Viewed 124 times


I am trying to create a report to display the top 100 customers that opened cases in a specified period. Is this possible to do with one report and without having to use the Auto Filter option to display the to 100? 
Kudos!
Solved!
Go to the Solution
Go to Solution
10-28-2009 02:51 PM
 
  Reply   Reply  

Re: Top 100 Report
Options    Options  
Bhagwan
Regular Contributor
Posts: 66


Bhagwan

Message 2 of 6

Viewed 117 times


I presume when you say top100 customers, you are identifying them by number of cases they have opened so far.Correct ?In that case you can click set sort desc on 'incident count' column (see  GIF) and under Level menu select record limit to set the rows you want to see

 

top100.GIF


 

Bhagwan Singh Mer
Kudos!
10-29-2009 03:30 AM
 
  Reply   Reply  

Re: Top 100 Report
Options    Options  
JLFolkman
New Advisor
Posts: 48


JLFolkman

Message 3 of 6

Viewed 108 times


Hi Bhagwan - I am trying to identify them by number of cases they have opened but I need to be able to run the report grouped by product so this will work if I run the report individually by product but not if grouping by product.
Kudos!
10-29-2009 11:10 AM
 
  Reply   Reply  

Re: Top 100 Report
Options    Options  
JLFolkman
New Advisor
Posts: 48


JLFolkman

Message 4 of 6

Viewed 106 times


This is what I'm trying to accomplish on one report. List by product the top 100 customers/organizations by the number of cases created for a specified time period.

 

Product XYZ   Customer   # Case Created

                        ABC                100

                        987                   99

                        .....                   98

 

Product 123    Customer    # Case Created

                         ABC                100

                         987                    99

                         ....                     98

 

 

Kudos!
10-29-2009 12:59 PM
 
  Reply   Reply  

Re: Top 100 Report
Options    Options  
Bhagwan
Regular Contributor
Posts: 66


Bhagwan

Message 5 of 6

Viewed 98 times


Ok..In that case you have to use custiom script as well. I have attached an xml report definition that List by product the top 3 customers by the number of cases created. See below image for custom script logic.

 

custom_script.JPG

 


 

Bhagwan Singh Mer

 

Attachment Top3 100138.xml (17 kb)

1
Kudos!
Accepted Solution
Accepted Solution
10-30-2009 12:12 AM
 
  Reply   Reply  

Re: Top 100 Report
Options    Options  
JLFolkman
New Advisor
Posts: 48


JLFolkman

Message 6 of 6

Viewed 77 times


This is exactly what I was looking for. Thank you!
Kudos!
11-03-2009 03:24 PM
 
Jump to Page:   1