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
04-26-2018 12:56 PM
Hi,
we have a Analytics search query for a header that returns the following payload.
{"QuoteID":"0409657629","
my query is
SELECT segments.httpData.headers.`application-data` AS "application-data", count(*) FROM transactions WHERE segments.httpData.headers.`application-data` = "{\"QuoteID\":\"*\",\"Annual premium\":\"*\",\"Line of business\":\"bop\",\"State\":\"UT\",\"AgencyCode\":\"*\",\"method\":\"getPPC\"}"
We are using the above query so that i can get data for each state by changing the value for state with the relevant abrevation. In the example above UT can be changed to MN etc.
We are am looking for a way that I can get the "Total Premium" by addidng all the Annual Premium ammounts.
please check attached image which shows the search result.
Is there a way we can use mathematical expression on part of the payload data.
Solved! Go to Solution.
04-30-2018 01:36 AM
Hi Ajay,
From the screenshot attached, I can see that Annual Premium ammounts is part of an array of values which I believe is returned from your Data Collector.
So in this case, first you need to tune your Data Collctor config in a way that you only get the return of Annual Premium ammounts value and then you can use ADQL SUM function to sum the required values based on matching criteria.
https://docs.appdynamics.com/display/PRO44/Analytics+Functions
Let me know if this helps.
Thanks,
Deepanshu
10-24-2018 08:37 AM
Have not heard back from the Client.
Thank you! Your submission has been received!
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form