ReportNet - How to create a Top N report?

[marcela79]

I have a list that has work orders, the equipment of the work order and the failure code.

I want to know based on a date parameter, what are the top 5 failure codes?

As of now, I have the counts of the work orders based on the failure codes but it does not sort by the calculated field in this case count(workorders); therefore I have to go through the whole document to find out which equipment has the most failure codes. How can I get the program to perform this for me?

How can I do this in ReportNet?

Thanks in advance for any help you can give me.

 

[JKas]

marcela79,

It seems that without seeing your data, that the work order is a unique number (i.e. #100, 101, 102, etc). If this is the case, try to "cut" it out of your list. This will keep it in the query, but remove from displaying. You should click on the Work Order column, the click on the "Edit" menu, then click "Cut"

Then you should be able to Aggregate on your count field. The results would look something like the following:

Equipment Failure Code Count
Widget1 F333 50
Widget1 F334 40
Widget1 F335 25

Widegt2 F333 5
Widget2 F334 10

Widget3 F333 30
Widget3 F335 20
Total 180

By "cutting" out the equipment code, the results should then look like the following:

Failure Code Count
F333 85
F334 50
F335 45
Total 180

I am just learning ReportNet, so if others offer better advice, they are probably correct.

Good Luck

 

[jmartelUT]

There is a rank function in ReportNet. Apply the rank function to your column and use a filter where rank <= N