Skip to main content
  • Name: _row_url
  • Type: string
  • Description: Define the URL to which the entire table links.
  • APL query example: extend _row_url = 'https://axiom.co/'
  • Expected behavior: Make rows clickable. When clicked, go to the specified URL.
If you specify a static string as the URL, all rows link to that page. To specify a different URL for each row, use an dynamic expression like extend _row_url = strcat('https://axiom.co/', uri) where uri is a field in your data.
  • Name: _FIELDNAME_url
  • Type: string
  • Description: Define a URL to which values in a field link.
  • APL query example: extend _website_url = 'https://axiom.co/'
  • Expected behavior: Make values in the website field clickable. When clicked, go to the specified URL.
Replace FIELDNAME with the actual name of the field.

​
Add tooltip to values in a field

  • Name: _FIELDNAME_tooltip
  • Type: string
  • Description: Define text to be displayed when hovering over values in a field.
  • Example Usage: extend _errors_tooltip = 'Number of errors'
  • Expected behavior: Display a tooltip with the specified text when the user hovers over values in a field.
Replace FIELDNAME with the actual name of the field.

​
Add description to values in a field

  • Name: _FIELDNAME_description
  • Type: string
  • Description: Define additional information to be displayed under the values in a field.
  • Example Usage: extend _diskusage_description = 'Current disk usage'
  • Expected behavior: Display additional text under the values in a field for more context.
Replace FIELDNAME with the actual name of the field.

​
Add unit of measurement

  • Name: _FIELDNAME_unit
  • Type: string
  • Description: Specify the unit of measurement for another field’s value allowing for proper formatting and display.
  • APL query example: extend _size_unit = "gbytes"
  • Expected behavior: Format the value in the size field according to the unit specified in the _size_unit field.
Replace FIELDNAME with the actual name of the field you want to format. For example, for a field named size, use _size_unit = "gbytes" to display its values in gigabytes in the query results. The supported units are the following: Percentage
Unit nameAPL sytax
percent (0-100)percent100
percent (0.0-1.0)percent
Currency
Unit nameAPL sytax
Dollars ($)curusd
Pounds (£)curgbp
Euro (€)cureur
Bitcoin (฿)curbtc
Data (IEC)
Unit nameAPL sytax
bits(IEC)bits
bytes(IEC)bytes
kibibyteskbytes
mebibytesmbytes
gibibytesgbytes
tebibytestbytes
pebibytespbytes
Data (metric)
Unit nameAPL sytax
bits(Metric)decbits
bytes(Metric)decbytes
kilobytesdeckbytes
megabytesdecmbytes
gigabytesdecgbytes
terabytesdectbytes
petabytesdecpbytes
Data rate
Unit nameAPL sytax
packets/secpps
bits/secbps
bytes/secBps
kilobytes/secKBs
kilobits/secKbits
megabytes/secMBs
megabits/secMbits
gigabytes/secGBs
gigabits/secGbits
terabytes/secTBs
terabits/secTbits
petabytes/secPBs
petabits/secPbits
Datetime
Unit nameAPL sytax
Hertz (1/s)hertz
nanoseconds (ns)ns
microseconds (µs)µs
milliseconds (ms)ms
seconds (s)secs
minutes (m)mins
hours (h)hours
days (d)days
agoago
Throughput
Unit nameAPL sytax
counts/sec (cps)cps
ops/sec (ops)ops
requests/sec (rps)reqps
reads/sec (rps)rps
writes/sec (wps)wps
I/O ops/sec (iops)iops
counts/min (cpm)cpm
ops/min (opm)opm
requests/min (rps)reqpm
reads/min (rpm)rpm
writes/min (wpm)wpm

​
Example

The example APL query below adds a tooltip and a description to the values of the status field. Clicking one of the values in this field leads to a page about status codes. The query adds the new field resp_body_size_bits that displays the size of the response body in the unit of bits. 
['sample-http-logs']
| extend _status_tooltip = 'The status of the HTTP request is the response code from the server. It shows if an HTTP request has been successfully completed.'
| extend _status_description = 'This is the status of the HTTP request.'
| extend _status_url = 'https://developer.mozilla.org/en-US/docs/Web/HTTP/Status'
| extend resp_body_size_bits = resp_body_size_bytes * 8
| extend _resp_body_size_bits_unit = 'bits'
Run in Playground