How to Calculate Time Saved from Automation Runs in ControlUp Dashboards Using Calculated Metrics

A user sought to create insights on time saved through automations by modifying the existing scripting and automation dashboard in ControlUp. Their goal was to add a calculated column that multiplies the number of successful script runs by a fixed value (such as 5 or 10) to estimate the total minutes saved. The user attempted to apply a mathematical transformation—specifically multiplying the “success-runs” metric by 10—via the dashboard’s JSON transformation editor. However, they encountered difficulties as the table widget was built using the advanced JSON builder, which does not support switching to the basic editor mode where simple calculated columns can be added or modified directly.

ControlUp’s community and support experts explained that the particular widget in question is created through the advanced JSON editor and does not support adding custom calculated columns directly on individual tables. The system currently does not allow adding a calculated column that multiplies existing columns in the advanced editor since it applies transformations to each column rather than enabling column-to-column calculations.

A recommended workaround is to use the associated “stat” widget found elsewhere on the same dashboard. This widget provides basic aggregated metrics and allows users to add simple calculations, such as multiplying the total number of successful script runs by a fixed number to calculate total time saved. By performing the multiplication in the stat widget rather than modifying the complex JSON table, users can achieve their insight goal effectively.

This limitation highlights that for advanced dashboards created via JSON editing in ControlUp, calculated columns that depend on arithmetic of existing columns must be created through simpler widgets or by recalculating the data outside the table visualization. Users aiming to customize time-saving metrics based on script run counts should consider leveraging stat widgets or other summary-level visualizations that support straightforward calculated metrics. For further guidance, ControlUp’s official documentation on the dashboard widgets and calculations can provide additional instructions: https://docs.controlup.com/display/DOCS/Dashboards and https://docs.controlup.com/display/DOCS/Data+Transforms.

Read the entire ‘How to Calculate Time Saved from Automation Runs in ControlUp Dashboards Using Calculated Metrics’ thread below:

Hey there!

I am trying to create insights on time saved based on automations. I am using the scripting and automation dashboard as a base. I want to either add a calculated column which multiplies the scripts that ran by 5 or 10 to calculate minutes saved. Or I want to multiply an existing value from the dashboard below to achieve the same result

I have tried to change the transformation, but it does not seem to work. For this particular table you can not change it to the basic editor to edit it there. Do i need to add the source ID from the data table?

I must be doing something wrong. Can anyone help me?

“`],
“transformations”: [
{
“id”: “success-runs”,
“plugin”: “Math”,
“sourceIds”: [
“success-runs”
],
“config”: {
“operation”: “multiply”,
“operand”: 10
}“`

Yeah this widget was build with the advanced json builder and cant be switched back. We also dont support currently to add a calculated column this will just calculaed each of the excisting columns

so you could just take the stat widget thats above it and add a calculation too it to get the number

Continue reading and comment on the thread ‘How to Calculate Time Saved from Automation Runs in ControlUp Dashboards Using Calculated Metrics’.  Not a member? Join Here!