Dashboard variables in Data Pipeline formulas

It is possible to reference dashboard variables in custom formulas within the Add Column Data Pipeline step.

In the following example, we have a hidden variable on our dashboard called {HIDDEN_VARIABLE} that contains a number value. We have a column in our chart called Amount, and we want to multiply it by our Hidden variable value.

We'll add an Add Column step in the Data Pipeline, choose Custom Formula, and add the following to the Formula field:

"Amount" * {HIDDEN_VARIABLE}

To view your list of variable names for reference, click Settings gear icon from your dashboard and choose the variables tab.