Dashboard chart does not match filter when clicking through

Hi all

I have this Dashboard/Chart on the landing page that's been setup by someone else. the red bar does not show the correct number (shows 25 count here) as when I click through to the filter it shows more.

Shows 226 once I click though

Can anyone point me to how I can go about fixing this? I'm not too familiar with Dashboards or Charts so I would need a bit of detail here on how I can fix this.

Thanks

0 Patrick McQueen 7 months ago

Hi sonesay inthavong,
The report uses a database query, whereas the ListView you are clicking through to uses API requests to structure the results. There are a few known issues between the way these two approaches handle the gathering of data. My interest is particularly piqued by the results being First Name = undefined, and wondering if the nature of these results are not being handled so gracefully by the API requests.
You can further investigate the report's MySQL query by showing the query in the user interface, as explained here:
https://support.sugarcrm.com/Documentation/Sugar_Versions/9.0/Pro/Application_Guide/Reports/#Show_Query
And you can use Chrome's Inspect feature to gather details about the API requests used in ListView.
Details about these could help ultimately point to the reason the two are returning different results.
I hope this helps.
Cancel
Up +1 Down

Reply

Verify Answer

Cancel