Chart unable to display selected data
Due to the sheet contains multiple different tables and I only wanted to display the data for this specific section, I was able to have the chart display the data selected I need at first
But after the workflow is ran and the sheet is updated the chart was unable to display the selected data anymore
Best Answer
-
@optimusprime123 for the report to capture just the row and columns that you highlighted, you just need to set the filter criteria in the report, for example: When Month is equals to "TOTAL FOLLOWERS FOR 2024". (Alternatively you can also create a helper column, for example: create a column "helper" with checkbox. Check the row that you want to capture. In the report filter criteria, states: When "Helper" column is checked.)
With this, the report will only pull the row that matches this criteria. In the report, select the 6 columns that you want to see. Then in your dashboard, create your chart with this report as the source.
Hope it works for you.
Answers
-
begs the question: what workflow?
-
@BullandKhmer Data Shuttle's workflow.
I had the smartsheet linked to an excel sheet via data shuttle
-
Hi,
I hope you're well and safe!
This could be due to the significant issues Smartsheet had in the last 24 hours.Does it work now?
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
@Andrée Starå nope still doesn't work sadly.
-
Did you have issues before? I've noticed I'm having issues too.
✅ Remember! Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
All my other charts seems working fine except for this one. But this chart is the only one where I grabbed the data by selecting the cells I want directly, while the rest of the chart were through a report.
I wonder if it has something to do with the way I grab the data, but it was able to show at first as I've mentioned above, until data shuttle workflow was updated. Even after I tried to remove and replace the chart again the issue still persist
-
@Andrée Starå All my other charts seems working fine except for this one. But this chart is the only one where I grabbed the data by selecting the cells I want directly, while the rest of the chart were through a report.
I wonder if it has something to do with the way I grab the data, but it was able to show at first as I've mentioned above, until data shuttle workflow was updated. Even after I tried to remove and replace the chart again the issue still persist
-
@optimusprime123 how about creating a report to capture this TOTAL row from the sheet and use this report to create the chart?
-
@Vivien Chong can a report able to grab by only a certain range of cells or from a particular cell/row only?
cause right now I couldn't use a report for the chart is because on my sheet contains multiple tables basically 3 different tables. as far as i'm concerned the report groups the data better when there's only one single table per sheet, it doesn't allow to group by selected range/cells (do correct me if i'm wrong)
i tried to make the chart by selecting the specific row i want, while it did work but it only work for like 30min until the backend workflow refreshes and updates the sheet again (i've the workflow job run for every 30min)
i could separate the tables into different sheets but would prefer not to, so i'm trying to see if there's any other alternatives.
-
@optimusprime123 for the report to capture just the row and columns that you highlighted, you just need to set the filter criteria in the report, for example: When Month is equals to "TOTAL FOLLOWERS FOR 2024". (Alternatively you can also create a helper column, for example: create a column "helper" with checkbox. Check the row that you want to capture. In the report filter criteria, states: When "Helper" column is checked.)
With this, the report will only pull the row that matches this criteria. In the report, select the 6 columns that you want to see. Then in your dashboard, create your chart with this report as the source.
Hope it works for you.
-
@Vivien Chong i just gave it a try, it did work! never thought of using the filter.
thanks for workaround solution!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 438 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 451 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives