View Data Shuttle Status on Dashboards

Jacob Minnich

Is there a way to display current Data Shuttle status and the last time a workflow ran on a dashboard? I'm frequently having to check Data Shuttle to see when a workflow ran last, and it would be useful to have this available via a report, widget, or embeddable content.

Gia Thinh

Hi @Jacob Minnich

I got this idea. In your sheet which updated by Data Shuttle, create Created, Modified columns and Last Update summary field as the creenshot below. Enter this formula in the summary field to calculate the last time that your sheet updated by the Data Shuttle workflow running.

=JOIN(DISTINCT(COLLECT(Modified:Modified, Modified:Modified, MAX(Modified:Modified))))

Then you can use the Last Update field to show the last time a workflow ran on a dashboard.

Jacob Minnich

Thank you! Is there an advantage to using Join-Distinct-Collect-Max instead of just using Max(Modified)?

Gia Thinh

Join-Distinct-Collect-Max returns a string of date and time, whereas MAX(Modified:Modified) returns a date only. The screenshot below shows the difference.

Gia Thinh

We can simplify the formula to have the same result of date and time as shown in Last Update 3 field.

=MAX(Modified:Modified) + ""

Jacob Minnich

Nevermind I see now. Without Join-Distinct-Collect the summary field won't pull in the timestamp.

Gia Thinh

I just updated the formula to make it simpler

=MAX(Modified:Modified) + ""