Progression chart

Simon Bamford

Hi everyone,

I have a questionnaire solution that only reports the latest attempt to answer it. It records how we as an organisation are doing against ICO Guidelines.

My manager has asked me to create a dashboard that shows progress. So a line chart that will show how the organisation is progressing.

My problem is the chart would need set up every time the questionnaire is filled in. I would have to go in and include the new data.

Would there be a way to automate that process?

The bottom 4 rows are where the data comes in. Each pair of columns would form its own line chart. It is currently set to receive a new line of data everyday. I then have to go to the dashboard and update the chart to include the new line added.

Thanks for taking a look.

Paul Newcome

You could use a report that automatically pulls in the rows you want based on how you set up the filters and then reference the report in the chart widget.

Paul Newcome

You could use a report that automatically pulls in the rows you want based on how you set up the filters and then reference the report in the chart widget.

Simon Bamford

https://community.smartsheet.com/discussion/comment/357651#Comment_357651

Thank you Paul. Was looking for a complicated solution to a simple solution. Thank you for the help.

Paul Newcome

Happy to help. 👍️