What is the best way to make a report that pulls from a very large sheet (14K+ lines)?
My source sheet is 14K+ lines and counting. Reports are limited to 2500 lines. Even when I have broken this data down by the quarter, this report is too large to even display all the data. What is the best way to support this?
Best Answers
-
Genevieve P. Employee Admin
Do you haveGrouping applied to your Report? Grouping will limit what the report can show:
However if youaren'tusing Grouping, the Report will allow you to page through all the data, as Paul mentioned:
Cheers,
Genevieve
-
Genevieve P. Employee Admin
I would either remove the Grouping and simply Sort by the values you're grouping by so you can manually page through the data, or set up multiple, grouped Reports, splitting up your information into smaller chunks (such as date ranges or specific grouped values).
Answers
-
Paul Newcome ✭✭✭✭✭✭
Reports are not limited to 2,500 lines. If you scroll to the bottom of the report, there should be a link to go to the next page.
-
There is no link at the bottom of the page. I have checked it from my screen and two other colleagues' screens; none of us see a link.
-
Genevieve P. Employee Admin
Do you haveGrouping applied to your Report? Grouping will limit what the report can show:
However if youaren'tusing Grouping, the Report will allow you to page through all the data, as Paul mentioned:
Cheers,
Genevieve
-
I do have grouping which is needed for this report; what is another way to pull a report with this large of a set. That message of 2500 grouping does not appear anymore with the filters I have selected but the report is still limited.
-
Genevieve P. Employee Admin
I would either remove the Grouping and simply Sort by the values you're grouping by so you can manually page through the data, or set up multiple, grouped Reports, splitting up your information into smaller chunks (such as date ranges or specific grouped values).
-
Paul Newcome ✭✭✭✭✭✭
@Genevieve P.Thank you. My next question was going to be about grouping but I got tied up with work.
Categories
Have you looked into creating a row report instead?<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":108574,"type":"question","name":"How can I tell if I have given access to multiple people to view a dashboard?","excerpt":"How do I give multiple access to a dashboard?","snippet":"How do I give multiple access to a dashboard?","categoryID":321,"dateInserted":"2023-08-06T04:51:50+00:00","dateUpdated":null,"dateLastComment":"2023-08-07T08:04:12+00:00","insertUserID":163646,"insertUser":{"userID":163646,"name":"DnG","title":"Supervisor","url":"https:\/\/community.smartsheet.com\/profile\/DnG","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTtcuZ11NboT_eH4KtLd0gvJv4c7-SMbjMO5l3xGGESPUEMI=s96-c","dateLastActive":"2023-08-06T20:01:36+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-08-08T15:27:02+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":41,"score":null,"hot":3382695962,"url":"https:\/\/community.smartsheet.com\/discussion\/108574\/how-can-i-tell-if-i-have-given-access-to-multiple-people-to-view-a-dashboard","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108574\/how-can-i-tell-if-i-have-given-access-to-multiple-people-to-view-a-dashboard","format":"Rich","lastPost":{"discussionID":108574,"commentID":389128,"name":"Re: How can I tell if I have given access to multiple people to view a dashboard?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/389128#Comment_389128","dateInserted":"2023-08-07T08:04:12+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-08-08T15:27:02+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-06T20:02:25+00:00","dateAnswered":"2023-08-06T11:31:01+00:00","acceptedAnswers":[{"commentID":389098,"body":"
Hi DnG,<\/p>
Click on Share button of your Dashboard and fill in emails that you want to give access.<\/p>