Sapiens.BI helps you produce effective reports with charts in a fast and easy way. It is a Sugar and SuiteCRM BI plug-in with powerful reporting capabilities, ease of use, elegant design, and a quick and easy setup. This Reporting Tool is easy to use, there is no need for technical knowledge or SQL. The Sapiens.BI tool comes with over 100 pre-built reports.
#1286 - Top N items in a group doesn't seem to work
Whenever I attempt to group by a column and use the Top N items I get no data back. If I leave it as All (blank) I get 100's of rows as expected with the group data having multiple rows per parent. But if I make this any type of number (e.g 1, 1000, etc) I get an empty result set.
6 years ago
Hello Stephen,
Thank you for your feedback! We will analyze this and get back to you as soon as we have any news: either additional questions or the fix, if we can repeat the issue on our test systems.
Thank you!
Best Regards, IT Sapiens Team