• Frustrated with standard reports (no DISTINCT clause), how can we use Enterprise (SQL) reports in dashlets?

    Hello Sugar lovers, We're regularly confronted to the limitations of the standard Sugar Reports module: No HAVING, no DISTINCT, no ability to make calculations... Currently our customers do not want to invest in third pary solutions (Discover and…

  • Dashlet not Appearing

    I have created a dashlet with the following files: asm-dashboard-new.js asm-dashboard-new.php manifest.php my-current-tasks-new.hbs my-tasks-due-new.hbs I have used the module loader to upload these in a zip file, with manifest.php at…

  • Access to user dashboards

    As an administrator, I want to see what the users are seeing on their dashboards. At the moment, I believe the only way I can do this is to borrow their credentials. Is there a better/easier way to do this? Even better would be the ability for an admin…

  • Options To Change Inactive Tasks Dashlet To Show Completed Tasks By Default

    Our users have added the Inactive Tasks dashlet to their Opportunity Focus Drawer dashboard. They would like the dashlet to default to seeing the Completed Tasks instead of the Deferred Tasks. What would be an approach to updating the Inactive Tasks…

  • Drill through not available in Dashlets

    Hi SugarClub members, I am new to SugarClub and learning from the topics already posted here. My issue is, in one of our Dashboards, there are many dashlets with bar and pie charts, and they are working fine. However, there are a few dashlets with…

  • How to add related module custom field to a dashlet column and filter

    Hello! We have a custom module Transactions which has relation to Accounts module custom field funded_c . How to show that field in the Transactions dashlet with possibility to filter? Searched a lot, but no similar cases found. Help!

  • Filter Dashboard List View by "Assigned to Me" and a second filter

    Using SugarCRM 10.2 (Sugar Serve cloud only): When applying a filter to a dashboard list view you can select the pre-made "Assigned to Me" filter, but then no other filter can be additionally applied. When creating a custom filter there seems to be…

  • Adding amount count to legends (pie charts)

    Hi Sugarclub, Im wondering if it's possible to easily display the number count of the statuses to a pie chart? For clarification, if there is 1 assigned case i would like it display e.g. "Assigned (1)" in the legend above. Best regards, P…

  • How to hide edit button in Dashboards module home sugarcrm 9.3?

    After update to 9.3 we have some error - View Render Failed, but our customization is very simple. ({ extendsFrom:'DashboardHeaderpaneView', initialize: function(options) { this._super("initialize", [options]); if( app.user.get('type')!= "admin" && this…

  • Maximum number of rows in a dashboard

    Where can I find the maximum number of rows that a dashboard can have? I'm having trouble finding it in the documentation.