dashboarding data where a row is added daily

Tony Rice

I've got a line graph visualizing data that grows daily (an API writes a new row each day).

Right now I'm editing the dashboard periodically and adjusting the range of rows and columns, including as many empty rows at the end as are available (only a handfull). While this saves from having to edit the dashboard daily, but still runs the risk of missing data and is just a pain to have to remember to do.

Is there a better way to accomplish keeping a chart up to date as data is not only updated but added? Perhaps updating dashboard objects via the API?

Andrée Starå

Hi @Tony Rice

I hope you're well and safe!

Couldn't you use a report instead?

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Tony Rice

Can you expand on your suggestion here? How would a report solve this problem?

Andrée Starå

@Tony Rice

The report would automatically be updated with the new data.

Make sense?

Do I misunderstand your need?

Tony Rice

Still not clear how this gets me any closer to a line graph that successfully incorporates daily updates.

Ajay Hulme

@Tony Rice , I am having the same issue. Currently, I have automation through various sheet creating trending data for me. However, I have not found a way to update the dashboard widgets automatically with the current data set in the source. I have also added a report to my dashboard to get into details, but my leaders respond to trends (specifically negative trends).

Automation adding rows and a report date to capture trending data.

Manually updating chart data on a daily basis. I will eventually move to weekly once a I have a bigger data set.