Smartsheet Basics
Smartsheet Basics
Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.
Create copy of Smartsheet data, scheduled and automated to be used as trendlines
I have created a PowerBI dashboard using smartsheets as the data source. Live updates are working perfectly, and updating data is running smoothly.
I have been asked to show a trend line, and progress with these metrics. How can I build a table (or Smartsheet) using snapshot data in an automated workflow using smartsheet?
Best Answer
-
You could leverage the idea of a KPI sheet and some automations as an intermediary between the "raw" data in Smartsheet and PBI. Basically, create a sheet that does your aggregation calculations for what you want to show as a trend. Then set up a Copy Row automation to push those calculations to another sheet that'll be your datasource for the historical data- and on that new sheet, include a Created column to capture the datestamp when the data are copied.
This of course presupposes that you won't need full drill-in capability for this historical trendline visualizations - if you do need full drill-in, this will get unwieldy quite fast.
If this answer resolves your question, please help the Community by marking it as an accepted answer. I'd also be grateful for your response - "Insightful"or "Awesome" reactions are much appreciated. Thanks!
Answers
-
You could leverage the idea of a KPI sheet and some automations as an intermediary between the "raw" data in Smartsheet and PBI. Basically, create a sheet that does your aggregation calculations for what you want to show as a trend. Then set up a Copy Row automation to push those calculations to another sheet that'll be your datasource for the historical data- and on that new sheet, include a Created column to capture the datestamp when the data are copied.
This of course presupposes that you won't need full drill-in capability for this historical trendline visualizations - if you do need full drill-in, this will get unwieldy quite fast.
If this answer resolves your question, please help the Community by marking it as an accepted answer. I'd also be grateful for your response - "Insightful"or "Awesome" reactions are much appreciated. Thanks!
-
Thanks for your reply, it was very helpful!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 208 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 84 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
