Issue with report not displaying all rows on Dashboard

Kristin R.

I created a report based on a date, which itself is the result of a formula based on a number + an Assigned Date. The report displays a count of each row that has a particular date. The issue is that the dashboard will not display the first row with a count (see screenshots). When I re-sort the data to display the newest date first vs. the oldest (and the newest date moves to the top), the newest date disappears. So it has something to do with that first row.

Has anyone experienced this? My colleague and I cannot find any reason for it, and this is not happening with my other reports - they are all displaying 100% of the data.

Genevieve P.

Hi @Kristin R.

It looks like you might have a setting toggled off in the Chart Widget - check to see if the first setting "Use column names as category labels" is turned on or off.

If this is toggled off, then the Chart will take the first row as the category labels, which may be why it's not showing up!

Cheers,

Genevieve

Claire Miller

Hi I am having this same problem! I have toggled off what Genevieve said to above but then it just removed the series labels without adding in the missing data.

Genevieve P.

Hi @Claire Miller

Can you post a screen capture of your Report and the Chart Settings (but block out sensitive data)?

Thanks!

Genevieve