Define variable in Action Flow

Question

I am using the function DATEDIFF in the dashboard in order to retreive the time elapsed between the creation of an order and the MAX time in the system.

To to this I store this last datetime in a variable, and I use it between quotes in the DATEDIFF function.

I can't use this workaround in Action Flow, hence it's giving me the following error: The operation failed with an error. 400: Wrong arguments for DATEDIFF: The aggregation function MAX cannot be used together with a dimension function input. Please check that there are no aggregations and dimensions used together as function inputs.

I've tried to store it as variable using the Set Variable tool, but differently from the analysis it doesn't directly retreive the value of the formula (in order to avoid the error above), but instead he just puts the formula inside the query data where I have the DATEDIFF.

How can I work this out?

Thanks

Page 1 / 1

Hello,

Have you tried creating a webhook to pass the variable that is storing the MAX time's value into your Action Flow, then using that variable within your Action Flow? Or passing the Action Flow to a skill, querying the data in the skill, and passing it back to another Action Flow?

Reply

tony.hoang11 · Answer

Hello,Have you tried creating a webhook to pass the variable that is storing the MAX time's value into your Action Flow, then using that variable within your Action Flow? Or passing the Action Flow to a skill, querying the data in the skill, and passing it back to another Action Flow?

Reply

ANY QUESTION?

MORE CELONIS

CHECK US IN

Reply

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded

ANY QUESTION?

MORE CELONIS

CHECK US IN