• Skip to main content

Suzanne Chiles

Technical communication

  • About Suzanne
  • Technical Writing Samples
  • Blogging
  • Contact Suzanne

Uncategorized

Use basic mode to specify data

October 2, 2019 by Suzanne Chiles Leave a Comment

Use the chart builder’s basic mode to create a chart without having to learn or use a query language. Basic mode guides you through the process. You can choose the source of the raw data, apply filters, and use other techniques to narrow the scope of the data in the chart.

We’ll be working with the example use case described in Specify your data to illustrate how to create a chart in basic mode.

Show All  
[show details]Step 1: Select the source of the data for a chart
Begin by specifying what data you want to view in your chart. Click in the View a chart with box to select the event type, an attribute, and a function to perform on the attribute.

You can use the event data dictionary to view information about an event type and its attributes on a single page. To see a tooltip with information about an event or attribute, hover over any term that has a dotted line underneath it.

Here are the results of using the event data dictionary to specify the data:

  • Event type. The Transaction event type measures a variety of data that describes what happens while a user is on a website, such as that user clicking on a button on a page.
  • Attribute. The name attribute stores information on all transactions.
  • Function. Select the unique_count function to get a count of all the transactions that occurred during the time frame.

Basic mode now shows the selection:

use-basic-step-one.png

one.newrelic.com [external link] > Chart builder > Basic > (event and attribute specified)

As you specify data, the chart updates to show you the results from the data you specified.

Based on the information specified so far, you can see a chart that shows the total number of transactions during the default time frame of 30 minutes. This total includes all transactions, whether the transaction was completed successfully or had errors.

crop-404-single-line.png

one.newrelic.com [external link] > Chart builder > Basic > (event and attribute specified)
[show details]Step 2: Filter the data
Your next step is to determine which of those transactions got a 404 page not found error. If you look at the event data dictionary for the Transaction event type, you’ll find this event also includes an attribute called httpResponseCode.

  • Narrow the results to show only those transactions where a page not found error occurred. Use the Narrow results to box to create this filter: httpResponseCode = 404 .
  • Because you want to be able to see the names of the apps that are resulting in the 404 errors, you use the Facet by box to see the results by appName (which is also an attribute for the Transaction event type). Faceting by appName updates the chart to break down the total number of 404 errors by the application names. This lets you know which apps are experiencing 404 errors.

Your chart now shows the line chart with a line for each app, each with its own color.

crop-basic-example-chart.png

one.newrelic.com [external link] > Chart builder > Basic > (event and attribute specified) > (filters and facets applied)
[show details]Step 3: Adjust time range and limits
You decide to focus on the five apps with the most page not found errors. The default value for the Limit field is 10, meaning that your chart will show the ten most relevant returns. You change that value to 5.

Customer support told you that they had been getting calls about these errors for a little over two hours. You decide to change the time range from the last 30 minutes to the last three hours so that you can view the errors during the time when the customers were calling support.

Now that you have the data set so that you are seeing exactly what you need, you can turn your attention to the appearance of the chart.

[show details]Step 4: Customize the chart
Because you are more interested in the total number of errors than a timeline view, you change the chart type to a bar chart.

cb-example-404-2-bar.png

one.newrelic.com > Chart builder > Basic > (event and attribute specified) > (filters and facets applied) > (time range and limit customized) > (chart type customized)

When you’re finished with your chart, you can add it to a dashboard or share it.

This table contains notes about using basic mode.

Item Description
Prompts You can start typing directly in an empty box; a list of items that match the information you type will display.
You can also click on an empty box to view a list of all of the items that are appropriate for the field, based on your earlier choices.
Saving a basic mode data specification Every time you run a query, that query is saved in the My recent queries dropdown in advanced (NRQL) mode [external link] .
Events Basic mode only supports data for one event and attribute.

If you want to use more than one event and/or attribute, use the SELECT statement in advanced (NRQL) mode.

Shortcuts Basic mode contains shortcuts that can display more complex events and attributes that aren’t generally supported, as in this example (which shows the tooltip for the shortcut).

crop-shortcut-tooltip.png

Example of the Response time histogram shortcut, showing a tooltip.
Tooltips Any time you see a dotted line under a term, you can hover over that term to see a tooltip with an explanation of the term.
Narrow by You can use more than one Narrow by definition in basic mode filter; the conditions will be joined by AND.

The WHERE clause in advanced (NRQL) allows OR in addition to AND.

If your query was started using basic mode and if you make changes to that query using advanced (NRQL) mode, you cannot return to basic mode to edit that query.

Any additional changes may only be made in advanced (NRQL) mode.

Use advanced (NRQL) mode to specify data

October 2, 2019 by Suzanne Chiles Leave a Comment

While basic mode is an excellent choice for creating charts without needing to know how to write queries, working in advanced (NRQL) mode offers more power and additional features.

Any data specified in basic mode can be written as an NRQL query in advanced (NRQL) mode.

To see what your basic mode data specification looks like as an NRQL query, click the Advanced (NRQL) inline-advanced-nrql.png link from the basic page.

cb-example-404-2-nrql.png

Example of an advanced (NRQL) query.

Compare advanced (NRQL) mode query with basic mode specification

When you switch from basic mode to advanced (NRQL) mode, the query you see produces the exact same chart as the basic data specification.

If your query was started using basic mode and if you make changes to that query using advanced (NRQL) mode, you cannot return to basic mode to edit that query.

Any additional changes may only be made in advanced (NRQL) mode.

Use this table to understand how basic mode specifications correspond to the equivalent NRQL query.

To set this In basic mode, you enter … In advanced (NRQL) mode, you write …
The event type, attribute, and function on that attribute View a chart with Transaction : Name : unique_count SELECT uniqueCount(name) FROM Transaction
Narrowing your results to show only those transactions with a 404 page not found error Narrow results to httpResponseCode='404' WHERE httpResponseCode = '404'
Enable a preliminary timeline view not needed in basic mode TIMESERIES — enables line chart type (required for initial chart view)
To see a separate value for each application with a 404 error Facet by appName FACET `appName`
To view the five applications with the most 404 errors

Limit 5 — default value is 10

LIMIT 5
To view errors over the last three hours Select Last 3 hrs — converted to seconds in NRQL query SINCE 10800 seconds ago
To enhance the results of sampling transaction data This feature is run automatically in basic mode EXTRAPOLATE

Notes about advanced (NRQL) mode

Queries written directly in NRQL can be more complex than queries written in basic mode. The NRQL documentation contains both reference information and query examples. This table identifies some items to keep in mind.

Item Description
Prompts For each statement or function in your query, you can view a list of valid options, with tooltips.

crop-prompt-nrql.png

Example of a prompt in advanced (NRQL) mode.

Events You can use multiple event types in an NRQL query.
Attributes You can use multiple attributes per event type in an NRQL query.
View previous queries Once you run an NRQL query, use the My recent queries dropdown to view up the last 1,000 queries that you ran. The dropdown has a search box to help you find your query.
Working with basic mode and NRQL If you start creating a chart using basic mode and then switch to advanced (NRQL), be aware that if you make any changes to the NRQL query, you will lose those changes in basic mode.
Autocompleter

The chart builder’s autocompleter will display events and attributes reported within the last 60 minutes. An example of this is a process that runs once a day, such as a standard system health check that kicks off every morning at 6:00 AM. If you attempt to query the event at 7:05 AM, the event and subsequent attributes will not be visible in the autocomplete dropdown.

These events and attributes are still queryable by typing the exact string.

WordPress Resources at SiteGround

May 15, 2016 by blogg518 Leave a Comment

WordPress is an award-winning web software, used by millions of webmasters worldwide for building their website or blog. SiteGround is proud to host this particular WordPress installation and provide users with multiple resources to facilitate the management of their WP websites:

Expert WordPress Hosting

SiteGround provides superior WordPress hosting focused on speed, security and customer service. We take care of WordPress sites security with unique server-level customizations, WP auto-updates, and daily backups. We make them faster by regularly upgrading our hardware, offering free CDN with Railgun and developing our SuperCacher that speeds sites up to 100 times! And last but not least, we provide real WordPress help 24/7! Learn more about SiteGround WordPress hosting

WordPress tutorial and knowledgebase articles

WordPress is considered an easy to work with software. Yet, if you are a beginner you might need some help, or you might be looking for tweaks that do not come naturally even to more advanced users. SiteGround WordPress tutorial includes installation and theme change instructions, management of WordPress plugins, manual upgrade and backup creation, and more. If you are looking for a more rare setup or modification, you may visit SiteGround Knowledgebase.

Free WordPress themes

SiteGround experts not only develop various solutions for WordPress sites, but also create unique designs that you could download for free. SiteGround WordPress themes are easy to customize for the particular use of the webmaster.

Copyright © 2023 Suzanne Chiles · Genesis Framework · WordPress ·