Correcting chart spacing
I am creating a chart on a dash board using a sheet summary report pulling data from 2 sheets.
I am having difficulty arranging the columns as desired no matter how I adjust the widget tools or the columns in the report
Specifically,
- One column that is pulling data from sheet "A" is on the left and the other 3 columns pulling from sheet "B" are on the right. I would very much like them to be in different order but cannot seem to move them.
- The one column from sheet "A" is separated from the others by a space many times that of the spacing between the other 3. I see no way in the tool to correct this.
This is the spacing that I cannot change
This is the order I want the columns to be in. The different rows are the different sheets.
Any suggestions would be appreciated!
Answers
-
Dale Murphy ✭✭✭✭✭✭@Carroll WallTo change the order of the columns, I think you need to reorder the summary fields in the source sheets. But they are on your widget in the order you wanted, just that there are several values that equal zero and this look like gaps.
The gaps are the tool performing as designed: it has left room for the other values, which appear to be zero for the first sheet.
dm
-
Carroll Wall ✭✭Thank you for replying.
If I understand what you are suggesting, the reason that the value for "# of OHSU evals" is on the left is that it is the first value of the top row of the report. And then the tool "reads" the rest of the values across then down to the next row and across. Therefore the large gap between the first and 2nd columns on the chart is due to the lack of data in the the last 2 top row cells. However if that was the case, why is there not also a gap between the 2nd and 3rd column due to the empty cell between them?
Or perhaps I am misunderstanding your meaning?
-
Dale Murphy ✭✭✭✭✭✭
@Carroll WallIt is tricky to be definitive without more data, but I believe each row is a new block of four data elements. So the left side should have blue/red/orange/green and the right side should have the same. The order is shown in the legend (I can't say for sure how that order was derived).
Missing (really, just equal to zero) are red/orange/green on the left (first row), blue on the right (second row). Hence the apparent gaps. I would add more data to clarify the pattern.
dm
Categories
It depends on your automation settings. If you set it to unrestricted, you can send to an email address in a cell without giving them access to the sheet. You can also specify which cells are provided in the update request within the automation builder.<\/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":106840,"type":"question","name":"Report not showing all rows that match the filter parameters","excerpt":"Hello! I have a sheet that has 3424 rows with a specific Due Date. When I look at that filter option in the report, I see that it sees 3424 for that field. However, when I add that parameter, only 2500 rows display. I can't find a row limit to reports that would cause this. Is there a row limit to reports that I'm unaware…","categoryID":321,"dateInserted":"2023-06-23T16:50:36+00:00","dateUpdated":null,"dateLastComment":"2023-06-23T17:36:10+00:00","insertUserID":74136,"insertUser":{"userID":74136,"name":"asimcock","url":"https:\/\/community.smartsheet.com\/profile\/asimcock","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-23T17:45:49+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-06-23T19:11:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":41,"score":null,"hot":3375083206,"url":"https:\/\/community.smartsheet.com\/discussion\/106840\/report-not-showing-all-rows-that-match-the-filter-parameters","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106840\/report-not-showing-all-rows-that-match-the-filter-parameters","format":"Rich","tagIDs":[265],"lastPost":{"discussionID":106840,"commentID":382043,"name":"Re: Report not showing all rows that match the filter parameters","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/382043#Comment_382043","dateInserted":"2023-06-23T17:36:10+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-06-23T19:11:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-23T17:47:12+00:00","dateAnswered":"2023-06-23T17:02:03+00:00","acceptedAnswers":[{"commentID":382031,"body":"
See this article. There is a 2500 row limit for reports.<\/p>
