Splunk Cloud Platform

Splunk Dashboard Studio

Escapes, quotation marks, and deltas in dynamic options syntax

When you use dynamic options syntax (DOS), there are formatting rules that you must follow. See the following sections to learn more about these rules:

Escaping characters in DOS

Dashboard definitions in Splunk Dashboard Studio are formatted using JSON. Because of JSON formatting, when you use certain characters in DOS, you need to escape them. When you escape a character, you indicate that the character you've escaped is part of the string's value, and not a JSON keyword.

In JSON, you escape a character by inserting a backslash in front of the character you'd like to escape. See the following table for an example of escaping a character:

Line without escaped character Line with escaped character
"> table | seriesByName("Purchases")" "> table | seriesByName(\"Purchases\")"

The following table lists all the characters you must escape in JSON:

Character Definition
" Double quotes
\ Backslash
/ Forward slash
\b Backspace
\f Form feed
\n Newline
\r Carriage return
\t Tab

Quotation marks in DOS

When you input a value in a DOS selector function or a DOS formatting function, you must wrap certain values in quotation marks. The following table shows the types of inputs you can use in a DOS selector or formatting function and whether you need to wrap quotation marks around the input. If you need to wrap quotation marks around the input, you must escape the quotation marks for JSON to properly parse your line of DOS. See Escaping characters in DOS for more information.

Type of input Quotation marks necessary? Example
Strings Yes "> table | seriesByName(\"Purchases\")"
Number No "> sparklineValues | delta(-2)"
JSON object in the context section of dashboard definition No "> trendValue | rangeValue(trendColorEditorConfig)"

Instead of escaping a double quotation mark in DOS, you can also use single quotes to wrap your input for a selector function. See the following table for an example of using single quotes compared to double quotes in DOS:

Single quotes Double quotes
"> table | seriesByName('Purchases')" "> table | seriesByName(\"Purchases\")"

To learn more about selector and formatting functions in DOS, see Selector and formatting functions.

Delta function in DOS

The delta function in DOS is a selector function. A selector function identifies and selects data associated with the visualization. The delta(index) function calculates the difference between the point at the index you pass into the delta function and the last point in the dataset.

You can pass in both positive and negative values to the delta function. A negative value indicates an offset from the end of the dataset. For example, delta(-2) calculates the difference between the second-to-last number in the dataset and the last number in the dataset.

In the following example, the delta function calculates the trend value in the dashboard based on the command delta(-2), which takes the difference between the second-to-last point in the dataset and the last point in the dataset. A single value visualization with a colored sparkline based on the trend of the visualization. The source code shows that the visualization contains a delta function. When you pass in a positive value to the delta function, the value of the positive number refers to its numerical index in the dataset. When you use the delta function, indices start at the value 0. For example, the delta(0) command calculates the difference between the first value in the dataset and the last value in the dataset. The delta(2) command calculates the difference between the third value in the dataset and the last value in the dataset.

Last modified on 10 January, 2024
Modify and write dynamic options syntax   Create a dashboard using REST API endpoints

This documentation applies to the following versions of Splunk Cloud Platform: 9.3.2408, 9.0.2305, 9.1.2308, 9.1.2312, 9.2.2403, 9.2.2406 (latest FedRAMP release)


Was this topic useful?







You must be logged into splunk.com in order to post comments. Log in now.

Please try to keep this discussion focused on the content covered in this documentation topic. If you have a more general question about Splunk functionality or are experiencing a difficulty with Splunk, consider posting a question to Splunkbase Answers.

0 out of 1000 Characters