Chart unable to display selected data

optimusprime123

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

Vivien Chong

@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.

BullandKhmer

begs the question: what workflow?

optimusprime123

@BullandKhmer Data Shuttle's workflow.

I had the smartsheet linked to an excel sheet via data shuttle

Andrée Starå

https://community.smartsheet.com/discussion/122559/chart-unable-to-display-selected-data

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?

https://status.smartsheet.com/

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!

optimusprime123

@Andrée Starå nope still doesn't work sadly.

Andrée Starå

https://community.smartsheet.com/discussion/comment/438073#Comment_438073

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!

optimusprime123

https://community.smartsheet.com/discussion/comment/438078#Comment_438078

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

https://community.smartsheet.com/discussion/comment/438078#Comment_438078

@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

Vivien Chong

@optimusprime123 how about creating a report to capture this TOTAL row from the sheet and use this report to create the chart?

optimusprime123

@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.

Vivien Chong

@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.

optimusprime123

@Vivien Chong i just gave it a try, it did work! never thought of using the filter.

thanks for workaround solution!