Progression chart

Simon Bamford · 01/18/23

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 · 01/18/23

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 · 01/18/23

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 · 01/19/23

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 · 01/19/23

Happy to help. 👍️

Progression chart

Best Answer

Answers

Help Article Resources

Categories