Capture metric each day and add to new row

Ezra · 05/13/20

I have a number of Harvey ball metrics (count of red, yellow, green tasks) and things that change every day. I haven't really seen any way to capture and store these each day at a particular time (or hourly, weekly, monthly). Anyone have a good solution for it?

Example of metrics I'm collecting on-the-fly from Control Center summary sheets... would love to be able to graph the health over time.. day by day.

L_123 · 05/13/20

The only way currently to convert a cell with a formula to a static cell is the copy/move workflows. You can set up a sheet to receive these, create a column that forces a change every day in the rows you want transferred even if there isn't a change in the data (example would be a =today() formula dragged down) and use that as criteria for the workflow.

Then base your charts off the historical data sheet.

L_123 · 05/13/20

The only way currently to convert a cell with a formula to a static cell is the copy/move workflows. You can set up a sheet to receive these, create a column that forces a change every day in the rows you want transferred even if there isn't a change in the data (example would be a =today() formula dragged down) and use that as criteria for the workflow.

Then base your charts off the historical data sheet.

Ezra · 05/14/20

I had completely forgotten about that workflow! Thanks!

Built the sheet that captures the data each day, made a couple reports to look at different ranges of time... and added some sample data to make sure it displays what I need.. perfect :)

Screen Shot 2020-05-14 at 12.00.28 PM.png

L_123 · 05/14/20

NP Glad it worked for you.

Capture metric each day and add to new row

Best Answer

Answers

Help Article Resources

Categories