Add top N filter to JasperServer report

Hi all,

is there a way to set a filter to show only top N results, for example I made a report that shows a chart with 40 bars,

so I want to do is to set the filter to show only top let's say 5 result.

Thank you

domagoj.hrzic's picture
Joined: Apr 28 2017 - 1:44am
Last seen: 2 years 11 months ago

1 Answer:

If you change the view type to a Crosstab, you can then right click on the measure column header in the crosstab and it will allow you to filter on the Top N or Bottom N values, as well as sort ascending or descending.  If you do this and then change the view type back to a chart, your bar chart will retain these settings and just show the top N bars.

pplaydon's picture
Joined: May 8 2017 - 11:18am
Last seen: 2 months 4 days ago