Not a customer? Click the 'Start a free trial' link to begin a 30-day SaaS trial of our product and to join our community.
Existing Cisco AppDynamics customers should click the 'Sign In' button to authenticate to access the community
11-15-2022 07:22 PM
I have created a custom metric that returns an integer, when used as a search...
SELECT count(*) FROM magento_order_flow WHERE completed = true and (round(toInt(STEP_6.eventTimestamp - STEP_2.eventTimestamp)/1000/60, 2)) > 3
The query returns a count of orders that completed a business journey, and took longer than 3 minutes, to complete.
It works great as a query. But when saved as a metric, it always returns a zero or a null, and I don't understand why.
Thanks for your help,
Greg
User | Count |
---|---|
3 | |
1 | |
1 | |
1 | |
1 |
Thank you! Your submission has been received!
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form