Show # of records instead of "All" in a report in a dashboard | Community
Skip to main content
O
OliviaMi
Level 4
February 2, 2021
Question

Show # of records instead of "All" in a report in a dashboard

  • February 2, 2021
  • 1 reply
  • 578 views

Is there a way to default reports to say the number of records instead of "All" at the bottom? We have the report set to show up to 200 records (instead of the standard 15), and it is embedded in a dashboard. Right now whenever we log in the report just shows "All" and we have to click on that to show the number (see screenshot). Thanks for any insights on this!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Doug_Den_Hoed_AtAppStore
Community Advisor
Doug_Den_Hoed_AtAppStoreCommunity Advisor
Community Advisor
February 3, 2021

Negative Olivia,

For performance reasons (presumably), “As Designed”, 200 is the maximum default rows loaded, and All must (then) be manually clicked.

As a hack, though...

Consider creating a chart (column charts often work well) that somehow shapes your data into meaningful groupings, and default your report to the chart tab: all the data will render, and in one click, you can open the data of behind the clicked portion of interest. As an example, see our One Chart To Rule Them All blog post.

Regards,

Doug

O
OliviaMiAuthor
Level 4
February 4, 2021

Thanks Doug! Our reports have less than 200 items in them though - my question is just if it can default to say "Showing all 45 projects" at the bottom of the list automatically. As it is now, the report just says "Showing All Projects" and the person has to go click on the little carrot there to show them the "Showing all 45 projects" each time they go into that dashboard - it's on additional click, and while it may not seem like a big deal - the less clicks the better for this group that is asking ;) Thank you!

Heather_Kulbacki
Community Advisor
Heather_KulbackiCommunity Advisor
Community Advisor
February 4, 2021

This is interesting. Here's a clip of a report that is sitting on one of our dashboards. It says "Showing all 13 projects" and there's no carot because that's all the lines for that report.

Other reports that we have on the dashboard set to show just 15 objects, but have more, show 15 of however many objects total there are

I wonder if this is a New Experience/Classic difference. We're using the New Experience, are you still in Classic??

Terms & ConditionsAccessibility statement

Loading footer...