by sapiens.bi

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.

Cancel at any time!
Free Trial

#1286 - Top N items in a group doesn't seem to work

Closed Bug? created by stephen Verified Purchase 6 years ago

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.

  1. sapiens-bi member avatar

    sapiens.bi Provider

    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

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
  • "Comprehensive tool that allows all types of advanced reports including audit tables, custom fields and combined reports."

    Read More Reviews