discuss.newrelic.com Open in urlscan Pro
162.247.242.35  Public Scan

Form analysis
1 forms found in the DOM

POST /login

<form id="hidden-login-form" method="post" action="/login" style="display: none;" __bizdiag="695534669" __biza="WJ__">
  <input name="username" type="text" id="signin_username">
  <input name="password" type="password" id="signin_password">
  <input name="redirect" type="hidden">
  <input type="submit" id="signin-button" value="Log In">
</form>

Text Content

Platform
Pricing
Solutions
Docs
Help Center
New Relic
Put all over the place in its place—monitor
your entire stack on a single platform.
Explore the platform
 * 470 integrations
   pre-built for you

Full-stack monitoring
 * Application Monitoring (APM)
 * Infrastructure Monitoring
 * Kubernetes & Pixie
 * Log Management
 * Network Monitoring

 * Browser Monitoring
 * Mobile Monitoring
 * Synthetics Monitoring
 * Serverless Monitoring
 * Model Performance
   Monitoring

Observability Experiences
 * CodeStream
 * Error Tracking
 * Vulnerability Management
 * Explorer
 * AIOps

Data Ingest & Insights
 * Integrations
 * Dashboards
 * Alerts
 * OpenTelemetry

Featured Customers
 * Bangkok Bank
   Scales rapidly and seamlessly
   to meet increased future demand
 * Workiva
   Takes observability to a new level
 * Viewpoint
   Improves engineering efficiency
   and customer transparency

Read all case studies
By use case
 * DevOps
 * Cloud Adoption
 * Tool Consolidation
 * Digital Customer Experience
 * Open Source

By Industry
 * Ecommerce and Retail
 * Healthcare
 * Media & Entertainment
 * New Relic for Startups
 * Nonprofit
 * Public Sector

By Technology
 * Amazon Web Services
 * Google Cloud Platform
 * Microsoft Azure
 * Pivotal Cloud Foundry
 * Prometheus Monitoring

Quick and easy set up

Get more value from your data with hundreds of quickstarts that integrate with
just about anything. Be up and running in minutes.

 

Get started
Build
 * Developer Hub
   Everything you need to build on New Relic
 * NerdLog
   Product updates and live demos
 * Open Source Projects
   Open source projects we maintain and support

Learn
 * Blog
   Industry updates, how-tos and best practices
 * New Relic University
   Training courses and certifications
 * Resources
   eBooks, datasheets, & white papers
 * Events & Webinars
   Join us for an upcoming event

Community and Support
 * The Relicans
   Community of developers
 * Community Forum
   Ask a question. Share an answer.
 * Technical Support
   Expert support for our global clients
 * Expert Services
   Let experts guide you with customized tech support

Skip to main content
Log InSign Up
 * 
 * 




WELCOME TO THE NEW RELIC COMMUNITY FORUM!

This is a public forum for users to discuss questions around software analytics,
performance monitoring, and using New Relic products.

To participate, just Log In with your New Relic account. Make sure to also
review our Community Guidelines, Terms of Service, and Privacy Policy.

X


Scheduled Maintenance for the EU Region will occur Saturday, August 20 from
20:00 UTC to 00:00 UTC (or Saturday, August 20 from 13:00 PDT to 17:00 PDT).
Customers in the EU region can expect a short service interruption at some point
during this timeframe which may include delays for certain data types and alert
condition modifications. Please reference https://status.newrelic.com/ for
updates.


FETCH APDEX BASED ON AN INPUT APDEX T FOR A PARTICULAR TRANSACTION

Support: Telemetry Data Platform (TDP)Dashboards
insights nrql

You have selected 0 posts.

select all

cancel selecting

Aug 2019
1 / 6
Aug 2019

Aug 2019

siddhant.agarwal
1
Aug '19


###Insights Question Template

 * There are many ways to achieve a goal in Insights, tell us a bit about your
   end goal. What insights are you hoping to gain?

Basically we want to fetch the Apdex score for a transaction using NRQL. For
that instead of using the global setting of Apdex Threshold, I want to fetch the
Apdex score for a Transaction (let’s say Transaction A) based on a configurable
T value.

For example: My application App_A, has a Apdex T set at 500ms. It has a
transaction Transaction_A, for which I need to get the Apdex score based on an
Apdex T, example: 200ms which is different than the one defined for the App_A.

Is it possible to do such a thing?

 * Please include the URL to the Insights dashboard that needs addressing:

 * Let us know which NRQL queries you have tried so far:

I tried the following so far for a T value of 1.5 seconds:

SELECT apdex(duration, t:1.5) FROM Transaction WHERE name =
‘WebTransaction/RestWebService/Transaction_A (GET)’ where appName = ‘App_A’

Is this query correct?
Helpful Resources:

 * NRQL syntax, components, and functions 2

 * Insights default data from other New Relic products 1

 * NRQL Library full of queries our customers use every day 1

Solved by wkiNewRelic in post #2


> Hi @siddhant.agarwal, you should use the where keyword only once and combine
> several criteria with and or or Another option would be to mark this
> transaction as key transaction and you can assign a specific apdex_T to it.
> This has the advantage that the Transaction table contains in the apdexPer…

1 Reply




 * CREATED
   
   Aug '19

 * LAST REPLY
   
   Aug '19
 * 5
   
   REPLIES

 * 2.5k
   
   VIEWS

 * 3
   
   USERS

 * 5
   
   LIKES

 * 4
   
   LINKS

 * 3
   
   

wkiNewRelicCertified Pro
Aug '19


Hi @siddhant.agarwal,

you should use the where keyword only once and combine several criteria with and
or or


siddhant.agarwal:

> SELECT apdex(duration, t:1.5) FROM Transaction WHERE name =
> ‘WebTransaction/RestWebService/Transaction_A (GET)’ and appName = ‘App_A’

Another option would be to mark this transaction as key transaction and you can
assign a specific apdex_T to it. This has the advantage that the Transaction
table contains in the apdexPerfZone column a value calculated on this base.

1 Reply
Solution
2


siddhant.agarwal
wkiNewRelic
Aug '19


ohh. Yes, sorry about that WHERE. That was just a copy paste error from my end.
Is there a restriction on the number of transactions that can be marked as Key
transactions?

1 Reply



wkiNewRelicCertified Pro
siddhant.agarwal
Aug '19


I’m not absolutely sure, but documentation 8 does not state an obvious limit.

1 Reply
2


siddhant.agarwal
wkiNewRelic
Aug '19


Thanks for the clarifications!




RyanVeitchNR Technical Account Manager
Aug '19


@siddhant.agarwal - @wkiNewRelic is right - there are no limits to key
transactions.

Thanks for helping out here @wkiNewRelic

1





Reply


SUGGESTED TOPICS

Topic Replies Views Activity uniqueCount with multiple attributes
Dashboards
welcome
2 334 May 30 dashboardCreateSnapshotUrl upstream request timeout
Dashboards
2 371 Jun 11 Change ownership of dashboard from a deleted user
Dashboards
1 205 Jun 30

Adding transaction chart to dashboard displays different information
Dashboards
2 201 Jul 5 Adding data manually into New Relic dashboard and create alerting
Dashboards
alerts dashboards documentation
2 145 17d


WANT TO READ MORE? BROWSE OTHER TOPICS IN DASHBOARDS OR VIEW LATEST TOPICS.


[EN.SHARE.TOPIC]



Share



 * About Us
 * Leadership
 * Careers
 * Social Impact

 * Newsroom
 * Customers
 * Partner Program
 * Investor Relations

 * Suppliers Portal
 * Security
 * ESG
 * Contact Us

FOLLOW US

 * 
 * 
 * 
 * 
 * 
 * 
 * 

  Terms of Service   Community Terms of Service   DMCA Policy   Privacy Policy
  Cookie Policy   UK Slavery Act of 2015   日本語   Français   Deutsch   한국어
©2008-22 New Relic, Inc. All rights reserved

Invalid date Invalid date