Explore functions reference

<body>
<div class="article-banners">
<div id="docs-wmp-link">
<a href="https://support.zendesk.com/hc/en-us/articles/5411234991258-plan" rel="noopener" target="_blank">What's my plan?</a>
</div>

<div class="article-banner" id="suite_pee">
<table>
<tbody>
<tr>
<td>
<strong>All Suites</strong>
</td>
<td>Professional, Enterprise, or Enterprise Plus</td>
</tr>
</tbody>
</table>
</div>

<div class="article-banner" id="support_with_explore_pe">
<table>
<tbody>
<tr>
<td>
<strong>Support with</strong>
</td>
<td>Explore Professional or Enterprise</td>
</tr>
</tbody>
</table>
</div>

</div>

<div class="body">

<p class="p">When you start to create your own custom metrics and attributes, you'll use functions a
lot to help you perform comparisons, calculations, and manipulations to your business
information.</p>
<p class="p">Explore offers many functions to help you work with, for example, dates, text strings,
calculations and more. Use this article as a reference to help you discover the
available functions and how to use them.</p>
<div class="p">
<div class="note tip">
<span class="tiptitle">Tip:</span> If any table columns are not visible on your screen, you can scroll sideways to see
them.</div>
</div>
<p class="p">This article contains the following topics:</p>
<ul class="ul" id="Explore_functions_reference__ul_tpx_cyg_dhb">
<li class="li"><a class="xref" href="#topic_y5p_f2n_dhb">Getting started</a></li>
<li class="li"><a class="xref" href="#topic_mfs_nqf_dhb">Basic mathematical operators</a></li>
<li class="li"><a class="xref" href="#topic_alh_4lf_dhb">Logical functions</a></li>
<li class="li"><a class="xref" href="#topic_ihb_zkf_dhb">Attribute functions</a></li>
<li class="li"><a class="xref" href="#topic_gz1_dz4_plb">Tag functions</a></li>
<li class="li"><a class="xref" href="#topic_l1t_plf_dhb">Text functions</a></li>
<li class="li"><a class="xref" href="#topic_i1d_vlf_dhb">Regex functions</a></li>
<li class="li"><a class="xref" href="#topic_rpl_mlf_dhb">Date functions</a></li>
<li class="li"><a class="xref" href="#topic_dmy_4lf_dhb">Numeric functions</a></li>
<li class="li"><a class="xref" href="#topic_pxj_rlf_dhb">Trigonometric functions</a></li>
<li class="li"><a class="xref" href="#topic_kmv_2yd_y2c">Comment functions</a></li>
</ul>
</div>
<div aria-labelledby="ariaid-title2" class="topic nested1" id="topic_y5p_f2n_dhb">
<h2 class="title topictitle2" id="ariaid-title2">Getting started</h2>
<div class="body">
<p class="p">You can browse for, and select functions when you create a standard calculated metric
or attribute. In the formula editing window, you can either begin to type the name
of a function or click <strong class="ph b">Add</strong> under <strong class="ph b">Functions</strong> and choose your function
from the list.</p>
<p class="p">When the function is added to a formula, it will appear with standard values. You
must replace these with the values you want to use in your formula. In this example,
you want to return only your tickets with subject lines beginning with
"[Flagged]".</p>
<ol class="ol" id="topic_y5p_f2n_dhb__ol_fml_yfn_dhb">
<li class="li">In the calculations menu (<img class="image" id="topic_y5p_f2n_dhb__image_y2p_zfn_dhb" src="https://zen-marketing-documentation.s3.amazonaws.com/docs/en/Explore_calculations.png">), click <strong class="ph b">Standard calculated attribute</strong>.</li>
<li class="li">Name your calculated attribute. This example uses <strong class="ph b">Subject begins with
[Flagged]</strong>.</li>
<li class="li">Under <strong class="ph b">Functions</strong>, click <strong class="ph b">Add</strong>.</li>
<li class="li">In the formula window, type IF .</li>
<li class="li">Under <strong class="ph b">Functions</strong>, click <strong class="ph b">Add</strong>.</li>
<li class="li">Search for <strong class="ph b">LEFTPART</strong>. Either use the search box, click <strong class="ph b">Filter</strong> to
scope the values down to the <strong class="ph b">Text</strong> category, or scroll through the list
until you find the function you want.</li>
<li class="li">Next to <strong class="ph b">LEFTPART</strong>, click <strong class="ph b">+</strong>.</li>
<li class="li">You'll now see the formula <strong class="ph b">IF LEFTPART(_text,_number)</strong>. Change the
<em class="ph i">_text</em> parameter to the Ticket Subject attribute. Either highlight
<strong class="ph b">_text</strong> and then choose <strong class="ph b">Ticket subject</strong> from the <strong class="ph b">Fields</strong>
menu, or amend the formula manually to add the attribute.<p class="p">The formula will now
read <strong class="ph b">IF LEFTPART([Ticket subject],_number)</strong></p>
</li>
<li class="li">Change the text _number to the number of characters you want to compare.
[Flagged] has nine characters, so enter <strong class="ph b">9</strong>.<p class="p">The formula will now read
<strong class="ph b">IF LEFTPART([Ticket subject],9)</strong></p>
</li>
<li class="li">Finally, add the condition we are searching for; in this case, the text
"[Flagged]". The final formula will read:<p class="p"><strong class="ph b">IF LEFTPART([Ticket
subject],9)="[Flagged]" THEN [TicketID] ENDIF</strong></p>
<p class="p"><img alt="Explore sample function" class="image img-screenshot" id="topic_y5p_f2n_dhb__image_qqp_h3n_dhb" src="https://zen-marketing-documentation.s3.amazonaws.com/docs/en/Explore_sample_function.png"></p>
</li>
</ol>
<p class="p">Now, when you use this attribute in your report, it will only return tickets with a
subject line beginning "[Flagged]".</p>
<p class="p">For more help and examples, see <a class="xref" href="https://support.zendesk.com/hc/en-us/articles/4408836190362-Navigating-the-Formula-window" target="_blank">Writing Explore formulas</a>.</p>
</div>
</div>
<div aria-labelledby="ariaid-title3" class="topic nested1" id="topic_mfs_nqf_dhb">
<h2 class="title topictitle2" id="ariaid-title3">Basic mathematical operators</h2>
<div class="body">
<p class="p">In addition to the above functions, you can also use the following basic mathematical
operators to perform calculations and connect text:</p>
<table border="1" cellpadding="4" cellspacing="0" class="simpletable" id="topic_mfs_nqf_dhb__simpletable_lgl_vqf_dhb" summary="">
<col style="width:50%">
<col style="width:50%">
<thead></thead>
<tbody>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">Operator</td>
<td class="stentry" style="vertical-align:top;">Description</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">+</td>
<td class="stentry" style="vertical-align:top;">Add two numeric values, or join two text strings.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">-</td>
<td class="stentry" style="vertical-align:top;">Subtract one value from another.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">*</td>
<td class="stentry" style="vertical-align:top;">Multiply two values</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">/</td>
<td class="stentry" style="vertical-align:top;">Divide one value by another</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">=</td>
<td class="stentry" style="vertical-align:top;">Test if one value is equal to another value</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">!=</td>
<td class="stentry" style="vertical-align:top;">Test if one value is not equal to another value</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">&gt;</td>
<td class="stentry" style="vertical-align:top;">
<p class="p">Test if the first value is greater than the following value (x&gt;y)</p>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">&lt;</td>
<td class="stentry" style="vertical-align:top;">
<p class="p">Test if the first value is less than the following value (x&lt;y)</p>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">&gt;=</td>
<td class="stentry" style="vertical-align:top;">
<p class="p">Test if the first value is greater than or equal to the following value
(x&gt;=y)</p>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">&lt;=</td>
<td class="stentry" style="vertical-align:top;">
<p class="p">Test if the first value is less than or equal to the following value
(x&lt;=y)</p>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">%</td>
<td class="stentry" style="vertical-align:top;">Computes the modulo (or remainder) after dividing one value by
another.<p class="p">Example: 5%2 returns 1, 20%3 returns 2</p>
</td>
</tr>
</tbody>
</table>
</div>
</div>
<div aria-labelledby="ariaid-title4" class="topic nested1" id="topic_alh_4lf_dhb">
<h2 class="title topictitle2" id="ariaid-title4">Logical functions</h2>
<div class="body">
<p class="p">These functions give you great flexibility in analyzing and presenting your
information just how you want.</p>
<table border="1" cellpadding="4" cellspacing="0" class="simpletable" id="topic_alh_4lf_dhb__simpletable_uyq_cmf_dhb" summary="">
<col style="width:50%">
<col style="width:50%">
<thead></thead>
<tbody>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">Function</td>
<td class="stentry" style="vertical-align:top;">Description</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">IF THEN ELSE Conditional expression</td>
<td class="stentry" style="vertical-align:top;">Enables you to evaluate logical values.<p class="p">Format: IF (<em class="ph i">condition</em>)
THEN (<em class="ph i">value if true</em>) ELSE (<em class="ph i">value if false</em>) ENDIF</p>
<p class="p">For
in-depth information about this function, see <a class="xref" href="https://support.zendesk.com/hc/en-us/articles/4408838560922-Using-the-IF-THEN-ELSE-function" target="_blank">Using the IF THEN ELSE
function</a>.</p>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">AND</td>
<td class="stentry" style="vertical-align:top;">Returns TRUE if the two supplied expressions are
TRUE.<p class="p">Example:</p>
<p class="p">IF ([Ticket channel]="Email") AND ([Submitter
email]="fred@fredco.com") THEN [Ticket ID] ENDIF</p>
<p class="p">Returns all
tickets that were received via. email from
fred@freedco.com.</p>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">OR</td>
<td class="stentry" style="vertical-align:top;">Returns TRUE if at least one of the supplied expressions is
TRUE.<p class="p">Example:</p>
<p class="p">IF ([Ticket channel]="Email") OR ([Ticket
channel]="Voice") THEN [Ticket ID] ENDIF</p>
<p class="p">Returns all tickets that
were received through either the email or voice channels.</p>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">NOT</td>
<td class="stentry" style="vertical-align:top;">Reverses the logical value of the supplied
expression.<p class="p">Example:</p>
<p class="p">IF NOT([Ticket channel]="Email") THEN
[Ticket ID] ENDIF</p>
<p class="p">Returns all tickets that were not received
through the email channel.</p>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">TRUE</td>
<td class="stentry" style="vertical-align:top;">Returns the logical value "TRUE".</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">FALSE</td>
<td class="stentry" style="vertical-align:top;">Returns the logical value "FALSE"</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">IN<em class="ph i">(_param,_array)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns TRUE if the first entered parameter is in the array specified
in the second parameter.<p class="p">Examples:</p>
<p class="p">IN(200,ARRAY(100,200,300,400))
returns TRUE</p>
<p class="p">IN(250,ARRAY(20,40,60,80)) returns
FALSE</p>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">SWITCH Conditional expression</td>
<td class="stentry" style="vertical-align:top;">SWITCH provides an easier-to-understand alternative to IF THEN ELSE
statements that have multiple branches.<p class="p">SWITCH (<em class="ph i">_tested_element</em>)
{</p>
<p class="p"> CASE _value1: <em class="ph i">_return_value</em></p>
<p class="p"> CASE _value2:
<em class="ph i">_return_value</em></p>
<p class="p"> DEFAULT:
<em class="ph i">_default_return_value</em></p>
<p class="p">}</p>
<p class="p">For in-depth information
about this function, see <a class="xref" href="https://support.zendesk.com/hc/en-us/articles/4408831957658-Adding-multiple-conditional-expressions-with-SWITCH" target="_blank">Adding multiple conditional
expressions with SWITCH</a>.</p>
</td>
</tr>
</tbody>
</table>
</div>
</div>
<div aria-labelledby="ariaid-title5" class="topic nested1" id="topic_ihb_zkf_dhb">
<h2 class="title topictitle2" id="ariaid-title5">Attribute functions</h2>
<div class="body">
<p class="p">These functions let you perform basic operations to quantify the number of attributes
returned by your report. You can also perform more advanced operations to "lock in"
or extend the aggregation level of your calculations.</p>
<table border="1" cellpadding="4" cellspacing="0" class="simpletable" id="topic_ihb_zkf_dhb__simpletable_jqm_hlf_dhb" summary="">
<col style="width:50%">
<col style="width:50%">
<thead></thead>
<tbody>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">Function</td>
<td class="stentry" style="vertical-align:top;">Description</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">COUNT_VALUES<em class="ph i">(_attribute)</em>
</td>
<td class="stentry" style="vertical-align:top;">Counts the number of values of the attribute you supply. Repeat values
are included. Can be used as a condition in calculated attributes and
metrics, but cannot be used in the THEN clause of a calculated
metric.<p class="p">Example: IF COUNT_VALUES([Ticket ID])&gt;30 THEN 1 ELSE 0 ENDIF
</p>
<p class="p">The example above returns 1 when there are more than 30 tickets,
and 0 when there are fewer than 30.</p>
<div class="p">
<div class="note tip" id="topic_ihb_zkf_dhb__note_mrf_wt1_kvb">
<span class="tiptitle">Tip:</span> If you want to create a metric
that counts the number of the values of an attribute, the metric
formula should be simply [Attribute]. You can then <a class="xref" href="https://support.zendesk.com/hc/en-us/articles/4408846897178-Choosing-metric-aggregators#topic_ycz_vxv_ngb" target="_blank">apply the COUNT aggregator</a>
as normal.</div>
</div>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">DCOUNT_VALUES(<em class="ph i">_attribute</em>)</td>
<td class="stentry" style="vertical-align:top;">Counts the distinct number of different values of the attribute you
supply. Can be used as a condition in calculated attributes and metrics, but
cannot be used in the THEN clause of a calculated metric.<p class="p">Example: IF
COUNT_VALUES([Organization name])&gt;100 THEN 1 ELSE 0 ENDIF </p>
<p class="p">The
example above returns 1 when there are more than 100 distinct
organizations, and 0 when there are fewer than 100.</p>
<div class="p">
<div class="note tip" id="topic_ihb_zkf_dhb__note_f41_j51_kvb">
<span class="tiptitle">Tip:</span> If you want to create a metric
that counts the number of distinct values of an attribute, the
metric formula should be simply [Attribute]. You can then <a class="xref" href="https://support.zendesk.com/hc/en-us/articles/4408846897178-Choosing-metric-aggregators#topic_ycz_vxv_ngb" target="_blank">apply the D_COUNT
aggregator</a> as normal.</div>
</div>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">ATTRIBUTE_FIX(<em class="ph i">aggregator</em>(<em class="ph i">metric name</em>), <em class="ph i">attribute1</em>,
<em class="ph i">attribute2</em>)</td>
<td class="stentry" style="vertical-align:top;">
<p class="p">Returns the value of <em class="ph i">aggregator</em>(<em class="ph i">metric name</em>) aggregated by
the attributes you specify (in this example <em class="ph i">attribute1</em> and
<em class="ph i">attribute2</em>). No other attributes can affect the results from
this metric.</p>
<p class="p"><a class="xref" href="https://support.zendesk.com/hc/en-us/articles/4408831146266#topic_m4c_hc2_zsb" target="_blank">Calculated attributes</a> can’t be
used inside of the ATTRIBUTE_FIX function.</p>
<p class="p">Example:</p>
<p class="p">ATTRIBUTE_FIX(MED(First Reply Time (min), [Ticket created - Year],
[Ticket created - Month])</p>
<p class="p">For more help and examples, see <a class="xref" href="https://support.zendesk.com/hc/en-us/articles/4408845551258" target="_blank">Working with aggregation level
functions</a>.</p>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">ATTRIBUTE_ADD(<em class="ph i">aggregator</em>(<em class="ph i">metric name</em>), <em class="ph i">attribute1</em>,
<em class="ph i">attribute2</em>)</td>
<td class="stentry" style="vertical-align:top;">
<p class="p">Returns the value of <em class="ph i">aggregator</em>(<em class="ph i">metric name</em>) aggregated to
all attributes in the report in addition to <em class="ph i">attribute1</em> and
<em class="ph i">attribute2</em>.</p>
<p class="p"><a class="xref" href="https://support.zendesk.com/hc/en-us/articles/4408831146266-Calculation-types-reference#topic_m4c_hc2_zsb" target="_blank">Calculated attributes</a> can’t be
used inside of the ATTRIBUTE_ADD function.</p>
<p class="p">Example:</p>
<p class="p">ATTRIBUTE_ADD(MED(First Reply Time (min), [Ticket created - Year],
[Ticket created - Month])</p>
<p class="p">For more help and examples, see <a class="xref" href="https://support.zendesk.com/hc/en-us/articles/4408845551258" target="_blank">Working with aggregation level
functions</a>.</p>
</td>
</tr>
</tbody>
</table>
</div>
</div>
<div aria-labelledby="ariaid-title6" class="topic nested1" id="topic_gz1_dz4_plb">
<h2 class="title topictitle2" id="ariaid-title6">Tag functions</h2>
<div class="body">
<p class="p">These functions help you search for the presence or absence of tags. This can include
ticket tags, call tags, or anything else that uses tags.</p>
<div class="p">
<div class="note important">
<span class="importanttitle">Important:</span> Only the functions in this section can be used to report on tags. Reports
might not work or return inaccurate results if you use functions not detailed
below.</div>
</div>
<table border="1" cellpadding="4" cellspacing="0" class="simpletable" id="topic_gz1_dz4_plb__simpletable_yrh_2z4_plb" summary="">
<col style="width:50%">
<col style="width:50%">
<thead></thead>
<tbody>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">Function</td>
<td class="stentry" style="vertical-align:top;">Description</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">INCLUDES_ALL([<em class="ph i">tag attribute</em>], "<em class="ph i">tag1</em>",
"<em class="ph i">tag2</em>")</td>
<td class="stentry" style="vertical-align:top;">Returns TRUE if all of the specified tags are included in the tag
attribute.<p class="p">Examples: </p>
<p class="p">INCLUDES_ALL([Ticket tags], "London",
"Milan") returns TRUE if a ticket contains the tags "London" and
"Milan".</p>
<p class="p">NOT INCLUDES_ALL ([Ticket tags], "London", "Milan")
returns TRUE if a ticket does not contain both of the tags "London" and
"Milan".</p>
<p class="p">For more examples of how to use this function, see <a class="xref" href="https://support.zendesk.com/hc/en-us/articles/4408838151450" target="_blank">Reporting with
tags</a>.</p>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">INCLUDES_ANY([<em class="ph i">tag attribute</em>], "<em class="ph i">tag1</em>",
"<em class="ph i">tag2</em>")</td>
<td class="stentry" style="vertical-align:top;">Returns TRUE if any of the specified tags are included in the tag
attribute.<p class="p">Examples: </p>
<p class="p">INCLUDES_ANY([Ticket tags], "London",
"Milan") returns TRUE if a ticket contains the tags "London" or
"Milan".</p>
<p class="p">NOT INCLUDES_ANY ([Ticket tags], "London", "Milan")
returns TRUE if a ticket does not contain either of the tags "London" or
"Milan".</p>
<p class="p">For more examples of how to use this function, see <a class="xref" href="https://support.zendesk.com/hc/en-us/articles/4408838151450" target="_blank">Reporting with
tags</a>.</p>
</td>
</tr>
</tbody>
</table>
</div>
</div>
<div aria-labelledby="ariaid-title7" class="topic nested1" id="topic_l1t_plf_dhb">
<h2 class="title topictitle2" id="ariaid-title7">Text functions</h2>
<div class="body">
<p class="p">These functions enable you to perform operations that search and evaluate text. You
can also modify text using formulas and patterns you create.</p>
<p class="p">For examples of how to use some of these text functions (like CONTAINS, LEFTPART,
SUBSTR, FIND, and LENGTH) see <a class="xref" href="https://support.zendesk.com/hc/en-us/articles/4408846701082" target="_blank">Explore recipe: Reporting on nested drop-down
fields</a>.</p>
<table border="1" cellpadding="4" cellspacing="0" class="simpletable" id="topic_l1t_plf_dhb__simpletable_gcv_bmf_dhb" summary="">
<col style="width:50%">
<col style="width:50%">
<thead></thead>
<tbody>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">Function</td>
<td class="stentry" style="vertical-align:top;">Description</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">CONTAINS<em class="ph i">(_text,_text_to_search)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns TRUE if the first entered parameter contains the second one as
a substring.<div class="p">Example: CONTAINS([Submitter name],"Sally")<ul class="ul" id="topic_l1t_plf_dhb__ul_prb_5sf_dhb">
<li class="li">Returns TRUE if the submitter name is "Sally Jones"</li>
<li class="li">Returns FALSE if the submitter name is "Rachel Jones"</li>
</ul>
</div>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">ENDSWITH<em class="ph i">(_text,_text_to_search)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns TRUE if the first supplied text ends with the second supplied
text.<p class="p">Example:</p>
<p class="p">ENDSWITH([US State],"ippi") returns TRUE for
Mississippi, but FALSE for Delaware.</p>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">FIND<em class="ph i">(_text,_text_to_find,_number_start_index)</em>
</td>
<td class="stentry" style="vertical-align:top;">
<p class="p">Returns the index, in the first entered text, of the first instance of
the second entered text, from the entered start index. Returns -1 if the
second entered text is not found. The index of the first character of a
string is 0.</p>
<p class="p">Examples:</p>
<p class="p">If [Ship Mode]="Urgent" then FIND([ShipMode","Norm",0) returns -1</p>
<p class="p">If [Ship Mode]="Normal" then FIND([ShipMode","ma",0) returns 3</p>
<p class="p">If [Ship Mode]="Urgent" then FIND([ShipMode","ge",2) returns 0</p>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">LEFTPART<em class="ph i">(_text,_number)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the leftmost <em class="ph i">_number</em> of characters in the supplied
text.<p class="p">Example:</p>
<p class="p">If [Department]="Technical documentation" then
LEFTPART([Department],9) returns "Technical"</p>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">LENGTH<em class="ph i">(_text)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the length (number of characters) of the supplied
text.<p class="p">Example:</p>
<p class="p">LENGTH([Product category]) returns the length of
each value of the Product category attribute.</p>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">LOWERCASE<em class="ph i">(_text)</em>
</td>
<td class="stentry" style="vertical-align:top;">Converts and returns the supplied text in lower case.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">LTRIM<em class="ph i">(_text)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the supplied attribute value with any whitespace to the left
removed.<p class="p">Example: LTRIM([Name]) would return "Peter " if [Name] is "
Peter "</p>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">REPLACE<em class="ph i">(_text,_text_to_replace,_text_to_replace_with)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns a copy of <em class="ph i">_text</em> in which all instances of
<em class="ph i">_text_to_replace</em> have been replaced with
<em class="ph i">_text_to_replace_with</em>.<p class="p">Example:</p>
<p class="p">IF [US State]="new York"
then REPLACE([US State],"n","N") returns "New York"</p>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">RIGHTPART<em class="ph i">(_text,_number)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the rightmost <em class="ph i">_number</em> of characters in the supplied
text.<p class="p">Example:</p>
<p class="p">If [Department]="Technical documentation" then
RIGHTPART([Department],13) returns "documentation"</p>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">RTRIM<em class="ph i">(_text)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the supplied attribute value with any whitespace to the right
removed.<p class="p">Example: TRIM([Name]) would return " Peter" if [Name] is "
Peter "</p>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">STARTSWITH<em class="ph i">(_text,_text_to_search)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns TRUE if the first supplied text starts with the second supplied
text.<p class="p">Example:</p>
<p class="p">STARTSWITH([US State],"Miss") returns TRUE for
Mississippi, but FALSE for Delaware.</p>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">IS_POSITIVE<em class="ph i">(_text)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns TRUE for positive and FALSE for negative based on analysis of
the text.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">SUBSTR<em class="ph i">(_text,_number_start_index,_number_end_index)</em>
</td>
<td class="stentry" style="vertical-align:top;">
<p class="p">Returns part of <em class="ph i">_text</em> consisting of the character specified by
start index (the first entered integer) and all characters up to end
index-1 (the second entered integer).</p>
<p class="p">Example: SUBSTR("Web marketing",0,3) returns "Web"</p>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">TRIM<em class="ph i">(_text)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the supplied attribute value with any whitespace to the left or
right removed.<p class="p">Example: TRIM([Name]) would return "Peter" if [Name] is "
Peter ":</p>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">UPPERCASE<em class="ph i">(_text)</em>
</td>
<td class="stentry" style="vertical-align:top;">Converts and returns the supplied text in upper case.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">STRING<em class="ph i">(_number)</em>
</td>
<td class="stentry" style="vertical-align:top;">Converts the supplied number into a string.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">LPAD<em class="ph i">(_text,_length,_pad)</em>
</td>
<td class="stentry" style="vertical-align:top;">Pads text to the left of <em class="ph i">_text</em> with <em class="ph i">_pad</em> until the string
is at <em class="ph i">_length</em>.<p class="p">Example:</p>
<p class="p">LPAD("1",7,"?") returns
"??????1"</p>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">RPAD<em class="ph i">(_text,_length,_pad)</em>
</td>
<td class="stentry" style="vertical-align:top;">Pads text to the right of <em class="ph i">_text</em> with <em class="ph i">_pad</em> until the
string is at <em class="ph i">_length</em>.<p class="p">Example:</p>
<p class="p">RPAD("1",7,"?") returns
"1??????"</p>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">LINK<em class="ph i">(_url,_label)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns a HTML link pointing to the supplied URL.<p class="p">For an example, see
<a class="xref" href="https://support.zendesk.com/hc/en-us/articles/4408839123226-Explore-recipe-Configuring-clickable-links-to-tickets" target="_blank">Explore recipe: Configuring clickable
links to tickets</a>.</p>
</td>
</tr>
</tbody>
</table>
</div>
</div>
<div aria-labelledby="ariaid-title8" class="topic nested1" id="topic_i1d_vlf_dhb">
<h2 class="title topictitle2" id="ariaid-title8">Regex functions</h2>
<div class="body">
<p class="p">A regular expression (sometimes known as a regex or regexp) is a sequence of
characters that define a search pattern. Explore contains support for using regular
expressions to accomplish the following calculations in your formulas:</p>
<table border="1" cellpadding="4" cellspacing="0" class="simpletable" id="topic_i1d_vlf_dhb__simpletable_pbr_ylf_dhb" summary="">
<col style="width:50%">
<col style="width:50%">
<thead></thead>
<tbody>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">Function</td>
<td class="stentry" style="vertical-align:top;">Description</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">REGEXP_MATCH<em class="ph i">(_text,_regexp)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns true if the text matches the regular expression.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">REGEXP_EXTRACT<em class="ph i">(_text,_regexp)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the portion of text that matches the capturing group in the
regular expression. For an example of how to use this function, see <a class="xref" href="https://support.zendesk.com/hc/en-us/articles/4408845536794" target="_blank">Can I report on user email domain in
Explore?</a>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">REGEXP_REPLACE<em class="ph i">(_text,_regexp,_replace_text)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns a string where any substring of text that matches the regular
expression is replaced by <em class="ph i">replace_text</em>.<p class="p">Example:
REGEXP_REPLACE("Hello","lo","p") returns "Help"</p>
</td>
</tr>
</tbody>
</table>
<p class="p">For more information about regular expressions, see <a class="xref" href="https://en.wikipedia.org/wiki/Regular_expression" target="_blank">this Wikipedia page</a>.</p>
</div>
</div>
<div aria-labelledby="ariaid-title9" class="topic nested1" id="topic_rpl_mlf_dhb">
<h2 class="title topictitle2" id="ariaid-title9">Date functions</h2>
<div class="body">
<p class="p">Explore lets you create, compare, and perform calculations on dates and times. These
functions are particularly useful because you'll likely spend a lot of time
examining your company information over a chosen date range.</p>
<table border="1" cellpadding="4" cellspacing="0" class="simpletable" id="topic_rpl_mlf_dhb__simpletable_tz1_dmf_dhb" summary="">
<col style="width:50%">
<col style="width:50%">
<thead></thead>
<tbody>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">Function</td>
<td class="stentry" style="vertical-align:top;">Description</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">DATE<em class="ph i">(_text)</em>
</td>
<td class="stentry" style="vertical-align:top;">Converts the supplied text into a date with a UTC timestamp. The
entered text can be in a variety of formats, but must at least include the
month, day, and year.<p class="p">Examples:</p>
<ul class="ul" id="topic_rpl_mlf_dhb__ul_pjl_yrj_yyb">
<li class="li">"2020-07-24T06:23:00+0200"</li>
<li class="li">"2020-07-24T06:23"</li>
<li class="li">"2020-07-24"</li>
<li class="li">"07/24/2020"</li>
<li class="li">"2020-Jul-24"</li>
<li class="li">"July-24-2020"</li>
</ul>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">DATE_EQUAL<em class="ph i">(_date,_date)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns TRUE if the two entered dates are equal.<p class="p">Example: IF
DATE_EQUAL([Ticket Created - Month],[Ticket Solved - Month]) THEN
[Ticket ID] ENDIF</p>
<p class="p">Returns all tickets that were solved in the same
month they were created. The year isn't included in this example so a
ticket that was created in June 2018 and solved in June 2020 would be
returned by this example.</p>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">DATE_NOT_EQUAL<em class="ph i">(_date,_date)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns TRUE if the two entered dates are not equal.<p class="p">Example: IF
DATE_EQUAL([Ticket Created - Month],[Ticket Solved - Month]) THEN
[Ticket ID] ENDIF</p>
<p class="p">Returns all tickets that were not solved in the
same month they were created.</p>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">DATE_LESS<em class="ph i">(_date,_date)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns TRUE if the first date is earlier than the second
date.<p class="p">Example: IF DATE_LESS([Ticket Assigned - Date],[Ticket Due -
Date - Date]) THEN [Ticket ID] ENDIF</p>
<p class="p">Returns all tickets that were
assigned before their due date.</p>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">DATE_LESS_OR_EQUAL<em class="ph i">(_date,_date)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns TRUE if the first date is earlier or the same as the second
date.<p class="p">Example: IF DATE_LESS_OR_EQUAL([Ticket Assigned - Date],[Ticket
Due - Date - Date]) THEN [Ticket ID] ENDIF</p>
<p class="p">Returns all tickets
that were assigned before or on their due date.</p>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">DATE_GREATER<em class="ph i">(_date,_date)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns TRUE if the first date is later than the second
date.<p class="p">Example: IF DATE_GREATER([Ticket Assigned - Date],[Ticket Due -
Date - Date]) THEN [Ticket ID] ENDIF</p>
<p class="p">Returns all tickets that were
assigned after their due date.</p>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">DATE_GREATER_OR_EQUAL<em class="ph i">(_date,_date)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns TRUE if the first date is later or the same as the second
date.<p class="p">Example: IF DATE_GREATER_OR_EQUAL([Ticket Assigned -
Date],[Ticket Due - Date - Date]) THEN [Ticket ID] ENDIF</p>
<p class="p">Returns
all tickets that were assigned on or after their due date.</p>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">DATE_ADD<em class="ph i">(_date,_date_part,_increment)</em>
</td>
<td class="stentry" style="vertical-align:top;">
<p class="p">Returns the given date in the user's time zone, updated by the entered
increment. The <em class="ph i">_date_part</em> parameter could be for example, 'year',
'quarter', 'month', 'day', 'hour', etc. The entered increment must be an
integer value, but it can be negative.</p>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">DATE_DIFF<em class="ph i">(_date,_date,_date_part)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the relative or exact difference between two dates in the
format you choose. <p class="p">In the function, <em class="ph i">_date_part</em> can be one of the
following:</p>
<p class="p">For relative differences (whole numbers):</p>
<ul class="ul" id="topic_rpl_mlf_dhb__ul_ogn_11g_dhb">
<li class="li">"year"</li>
<li class="li">"half_year"</li>
<li class="li">"quarter"</li>
<li class="li">"month"</li>
<li class="li">"day"</li>
<li class="li">"hour"</li>
<li class="li">"minute"</li>
<li class="li">"second"</li>
</ul>
<p class="p">For exact values:</p>
<ul class="ul" id="topic_rpl_mlf_dhb__ul_ivy_j1g_dhb">
<li class="li">"nb_of_years"</li>
<li class="li">"nb_of_half_years"</li>
<li class="li">"nb_of_quarters"</li>
<li class="li">"nb_of_months"</li>
<li class="li">"nb_of_days"</li>
<li class="li">"nb_of_hours"</li>
<li class="li">"nb_of_minutes"</li>
<li class="li">"nb_of_seconds"</li>
</ul>
<p class="p">Examples:</p>
<p class="p">DATE_DIFF("2011/10/22","2008/01/06","year") returns
3 (2011-2008)</p>
<p class="p">DATE_DIFF("2011/10/22","2008/01/06","nb_of_years")
returns 4 (actual count of
years)</p>
<p class="p">DATE_DIFF("2019/03/06","2017/03/05","day") returns
1</p>
<p class="p">DATE_DIFF("2019/03/06","2017/03/05","nb_of_days") returns
731</p>
<p class="p">Use only one custom timestamp. If you attempt to use two, no
results are returned.</p>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">DATE_FORMAT<em class="ph i">(_date,_format)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the entered date in the user's time zone in the supplied
format.<p class="p">For a list of the formats you can use, see <a class="xref" href="#topic_esm_5qg_dhb">Formatting dates</a>.</p>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">TODAY<em class="ph i">()</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the current date in the user's time zone.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">NOW<em class="ph i">()</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the current date and time in the user's time zone (in hours,
minutes, and seconds).</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">CURRENT_YEAR<em class="ph i">()</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the current year.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">CURRENT_HALFYEAR<em class="ph i">()</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the current semester as "H1" or "H2"</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">CURRENT_QUARTER<em class="ph i">()</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the current quarter as "Q1", "Q2", "Q3", or "Q4"</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">CURRENT_MONTH<em class="ph i">()</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the current month, for example "January", "February".</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">CURRENT_MONTH_NUMERIC<em class="ph i">()</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the current month as a number, for example "1" for January, "2"
for February.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">CURRENT_DAY<em class="ph i">()</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the current day as a number.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">CURRENT_WEEKDAY<em class="ph i">()</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the current day of the week as text, for example "Monday",
"Tuesday".</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">CURRENT_WEEKDAY_NUMERIC<em class="ph i">()</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the current day of the week as a number, for example "0" for
Sunday, "1" for Monday.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">CURRENT_HOUR<em class="ph i">()</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the current hour in the user's time zone as a number.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">CURRENT_MINUTE<em class="ph i">()</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the current minute in the user's time zone as a
number.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">CURRENT_SECOND<em class="ph i">()</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the current second in the user's time zone as a
number.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">YEAR<em class="ph i">(_date)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the year of the supplied date.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">MONTH<em class="ph i">(_date)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the month of the supplied date as text, for example "January",
"February"</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">MONTH_NUMERIC<em class="ph i">(_date)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the month of the supplied date as a number, for example "1" for
January, "2" for February. </td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">DAY<em class="ph i">(_date)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the day of the supplied date.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">WEEKDAY<em class="ph i">(_date)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the day of the supplied date as a string, for example "Monday",
"Tuesday".</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">WEEKDAY_NUMERIC<em class="ph i">(_date)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the day of the supplied date as a number, for example "1" for
Sunday, "2" for Monday.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">HOURS<em class="ph i">(_date)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the hour of the supplied date.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">MINUTES<em class="ph i">(_date)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the minute of the supplied date.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">SECONDS<em class="ph i">(_date)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the second of the supplied date.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">WEEK_NUMBER<em class="ph i">(_date)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the week number associated with the supplied date. See <a class="xref" href="https://support.zendesk.com/hc/en-us/articles/4418307079322#topic_ibw_tym_htb" target="_blank">Understanding how the start of the week
affects week numbers</a>.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">WEEK_NUMBER_MONDAY<em class="ph i">(_date)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the week number associated with the supplied date starting on
Monday.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">WEEK_NUMBER_FRIDAY<em class="ph i">(_date)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the week number associated with the supplied date starting on
Friday.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">WEEK_NUMBER_SATURDAY<em class="ph i">(_date)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the week number associated with the supplied date starting on
Saturday.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">WEEK_NUMBER_SUNDAY<em class="ph i">(_date)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the week number associated with the supplied date starting on
Sunday.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">START_OF_QUARTER<em class="ph i">(_date)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the start of the quarter for the supplied date.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">END_OF_QUARTER<em class="ph i">(_date)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the end of the quarter for the supplied date.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">START_OF_MONTH<em class="ph i">(_date)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the start of the month for the supplied date.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">END_OF_MONTH<em class="ph i">(_date)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the end of the month for the supplied date.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">START_OF_WEEK<em class="ph i">(_date)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the start of the week for the supplied date. See <a class="xref" href="https://support.zendesk.com/hc/en-us/articles/4418307079322" target="_blank">Setting the start of the week for reports
and filters</a>.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">END_OF_WEEK<em class="ph i">(_date)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the end of the week for the supplied date. See <a class="xref" href="https://support.zendesk.com/hc/en-us/articles/4418307079322" target="_blank">Setting the start of the week for reports
and filters</a>.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">START_OF_WEEK_MONDAY<em class="ph i">(_date)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the start of the week that matches the supplied date with the
week starting on Monday.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">END_OF_WEEK_MONDAY<em class="ph i">(_date)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the end of the week that matches the supplied date with the
week starting on Monday.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">START_OF_WEEK_FRIDAY<em class="ph i">(_date)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the start of the week that matches the supplied date with the
week starting on Friday.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">END_OF_WEEK_FRIDAY<em class="ph i">(_date)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the end of the week that matches the supplied date with the
week starting on Friday.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">START_OF_WEEK_SATURDAY<em class="ph i">(_date)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the start of the week that matches the supplied date with the
week starting on Saturday.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">END_OF_WEEK_SATURDAY<em class="ph i">(_date)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the end of the week that matches the supplied date with the
week starting on Saturday.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">START_OF_WEEK_SUNDAY<em class="ph i">(_date)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the start of the week that matches the supplied date with the
week starting on Sunday.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">END_OF_WEEK_SUNDAY<em class="ph i">(_date)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the end of the week that matches the supplied date with the
week starting on Sunday.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">DATE_FROM_ISO</td>
<td class="stentry" style="vertical-align:top;">Returns a timestamp if the parameter is an ISO standard timestamp
string. Assumes that the timestamp has a timezone, but timestamps without
timezone information can be parsed by setting the optional skip-timezone
parameter to
TRUE.<p class="p">Examples:</p>
<p class="p">DATE_FROM_ISO("2020-07-24T13:42:00Z")</p>
<p class="p">DATE_FROM_ISO("2020-07-24T13:42EST")</p>
<p class="p">DATE_FROM_ISO("2020-07-24T13:42+05")</p>
<p class="p">DATE_FROM_ISO("2020-07-24T13:42,"
TRUE)</p>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">DATE_FROM_TIMESTAMP<em class="ph i">(_timestamp)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns a date from a supplied <a class="xref" href="https://www.unixtimestamp.com/" target="_blank">UNIX timestamp</a> in seconds.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">DATE_FROM_MILLI_TIMESTAMP<em class="ph i">(_timestamp)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns a date from a supplied <a class="xref" href="https://www.unixtimestamp.com/" target="_blank">UNIX timestamp</a> in milliseconds.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">DATE_TO_TIMESTAMP<em class="ph i">(_date)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns a <a class="xref" href="https://www.unixtimestamp.com/" target="_blank">UNIX timestamp</a> in the user's time zone from a
supplied date.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">DATE_TO_MILLI_TIMESTAMP<em class="ph i">(_date)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns a <a class="xref" href="https://www.unixtimestamp.com/" target="_blank">UNIX timestamp</a> in milliseconds from a supplied
date.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">SECONDS_TO_TIME<em class="ph i">(_time)</em>
</td>
<td class="stentry" style="vertical-align:top;">Converts seconds to HH:MM:SS format.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">FISCAL_YEAR<em class="ph i">(_date,_start_month)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the fiscal year based on the supplied date and start month. The
<em class="ph i">month</em> parameter must be the full name of the month (e.g.,
"February", not "Feb").</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">FISCAL_QUARTER<em class="ph i">(_date,_start_month)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the fiscal quarter based on the supplied date and start month.
The <em class="ph i">month</em> parameter must be the full name of the month (e.g.,
"February", not "Feb").</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">FISCAL_WEEK_NUMBER<em class="ph i">(_date,_start_month)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the fiscal week number based on the supplied date and start
month. The <em class="ph i">month</em> parameter must be the full name of the month (e.g.,
"February", not "Feb").</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">WEEKYEAR<em class="ph i">(_date)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the year of the week number associated with the supplied
date.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">DATE_FIRST(<em class="ph i">time attribute</em>)</td>
<td class="stentry" style="vertical-align:top;">
<p class="p">Returns the earliest date or timestamp according to attributes added to
the report and is affected by all applied filters.</p>
<p class="p">Example: DATE_FIRST([Update - Timestamp])</p>
<p class="p">Returns the earliest update timestamp taking into account all attributes
you added to the report.</p>
<p class="p">For more help and examples, see <a class="xref" href="https://support.zendesk.com/hc/en-us/articles/4408833381402" target="_blank">Working with earliest and latest date
functions</a>.</p>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">DATE_LAST(<em class="ph i">time attribute</em>)</td>
<td class="stentry" style="vertical-align:top;">
<p class="p">Returns the latest date or timestamp according to attributes added to the
report and is affected by all applied filters.</p>
<p class="p">Example: DATE_LAST([Update - Timestamp])</p>
<p class="p">Returns the latest update timestamp taking into account all attributes
you added to the report.</p>
<p class="p">For more help and examples, see <a class="xref" href="https://support.zendesk.com/hc/en-us/articles/4408833381402" target="_blank">Working with earliest and latest date
functions</a>.</p>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">DATE_FIRST_FIX(<em class="ph i">time attribute, attribute1, attribute2,
...</em>)</td>
<td class="stentry" style="vertical-align:top;">
<p class="p">Returns the earliest date or timestamp according to the attributes
specified in the function. Attributes added to the report will not
affect the calculation but any filters applied will be taken into
account.</p>
<p class="p">Example: DATE_FIRST_FIX([Update - Timestamp], [Update ticket ID])</p>
<p class="p">Returns the earliest update timestamp per ticket, regardless of the
attributes from the report.</p>
<p class="p">For more help and examples, see <a class="xref" href="https://support.zendesk.com/hc/en-us/articles/4408833381402" target="_blank">Working with earliest and latest date
functions</a>.</p>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">DATE_LAST_FIX(<em class="ph i">time attribute, attribute1, attribute2,
...</em>)</td>
<td class="stentry" style="vertical-align:top;">
<p class="p">Returns the latest date or timestamp according to the attributes
specified in the function. Attributes added to the report will not
affect the calculation but any filters applied will be taken into
account.</p>
<p class="p">Example:</p>
<p class="p">DATE_LAST_FIX([Update - Timestamp], [Update ticket ID])</p>
<p class="p">Returns the latest update timestamp per ticket, regardless of the
attributes from the report.</p>
<p class="p">For more help and examples, see <a class="xref" href="https://support.zendesk.com/hc/en-us/articles/4408833381402" target="_blank">Working with earliest and latest date
functions</a>.</p>
</td>
</tr>
</tbody>
</table>
</div>
<div aria-labelledby="ariaid-title10" class="topic nested2" id="topic_esm_5qg_dhb">
<h3 class="title topictitle3" id="ariaid-title10">Formatting dates</h3>
<div class="body">
<p class="p">The DATE_FORMAT function render full timestamps as different types of dates. Each
format is represented by a different letter. You enter the associated letter in
the format part of the <strong class="ph b">DATE_FORMAT</strong> function. Letters must be entered in
double quotes. You can combine the date or time components to display more
information about a date.</p>
<p class="p">For example, to change the default format (2015-01-27T13:21:10) of the <strong class="ph b">Ticket
created - Timestamp</strong> attribute to a US-style format (Jan 27, 2015 01:21
PM), use this formula: </p>
<div class="p">
<pre class="pre" id="topic_esm_5qg_dhb__pre_hh4_stj_yyb">DATE_FORMAT([Ticket created - Timestamp],"Mon DD, YYYY hh:MI AM")</pre>
</div>
<p class="p">The table shows formats you can use. The examples use the timestamp
2017-11-03T15:18:25.</p>
<div class="p">
<div class="tablenoborder">
<table border="1" cellpadding="4" cellspacing="0" class="table" dir="ltr" frame="border" id="topic_esm_5qg_dhb__table_nnc_lsj_yyb" rules="all" summary="">
<colgroup>
<col>
<col>
<col>
</colgroup>
<tbody class="tbody">
<tr class="row">
<td class="entry nocellnorowborder" style="vertical-align:top;">Date or time component</td>
<td class="entry nocellnorowborder" style="vertical-align:top;">Letter</td>
<td class="entry cell-norowborder" style="vertical-align:top;">Example using 2017-11-03T15:18:25</td>
</tr>
<tr class="row">
<td class="entry nocellnorowborder" style="vertical-align:top;">Year</td>
<td class="entry nocellnorowborder" style="vertical-align:top;">YYYY</td>
<td class="entry cell-norowborder" style="vertical-align:top;">2017</td>
</tr>
<tr class="row">
<td class="entry nocellnorowborder" style="vertical-align:top;">Year</td>
<td class="entry nocellnorowborder" style="vertical-align:top;">YY</td>
<td class="entry cell-norowborder" style="vertical-align:top;">17</td>
</tr>
<tr class="row">
<td class="entry nocellnorowborder" style="vertical-align:top;">Quarter</td>
<td class="entry nocellnorowborder" style="vertical-align:top;">Q</td>
<td class="entry cell-norowborder" style="vertical-align:top;">Q4</td>
</tr>
<tr class="row">
<td class="entry nocellnorowborder" style="vertical-align:top;">Month number</td>
<td class="entry nocellnorowborder" style="vertical-align:top;">MM</td>
<td class="entry cell-norowborder" style="vertical-align:top;">11</td>
</tr>
<tr class="row">
<td class="entry nocellnorowborder" style="vertical-align:top;">Month name</td>
<td class="entry nocellnorowborder" style="vertical-align:top;">Mon</td>
<td class="entry cell-norowborder" style="vertical-align:top;">Nov</td>
</tr>
<tr class="row">
<td class="entry nocellnorowborder" style="vertical-align:top;">Month name</td>
<td class="entry nocellnorowborder" style="vertical-align:top;">Month</td>
<td class="entry cell-norowborder" style="vertical-align:top;">November</td>
</tr>
<tr class="row">
<td class="entry nocellnorowborder" style="vertical-align:top;">Week of year (1–53)</td>
<td class="entry nocellnorowborder" style="vertical-align:top;">WW</td>
<td class="entry cell-norowborder" style="vertical-align:top;">44</td>
</tr>
<tr class="row">
<td class="entry nocellnorowborder" style="vertical-align:top;">Week of month (1-5)</td>
<td class="entry nocellnorowborder" style="vertical-align:top;">W</td>
<td class="entry cell-norowborder" style="vertical-align:top;">1</td>
</tr>
<tr class="row">
<td class="entry nocellnorowborder" style="vertical-align:top;">Day number of year (01-366)</td>
<td class="entry nocellnorowborder" style="vertical-align:top;">DDD</td>
<td class="entry cell-norowborder" style="vertical-align:top;">307</td>
</tr>
<tr class="row">
<td class="entry nocellnorowborder" style="vertical-align:top;">Day number of month (01-31)</td>
<td class="entry nocellnorowborder" style="vertical-align:top;">DD </td>
<td class="entry cell-norowborder" style="vertical-align:top;">3</td>
</tr>
<tr class="row">
<td class="entry nocellnorowborder" style="vertical-align:top;">Day name of week</td>
<td class="entry nocellnorowborder" style="vertical-align:top;">Day</td>
<td class="entry cell-norowborder" style="vertical-align:top;">Friday</td>
</tr>
<tr class="row">
<td class="entry nocellnorowborder" style="vertical-align:top;">Day name of week</td>
<td class="entry nocellnorowborder" style="vertical-align:top;">Dy</td>
<td class="entry cell-norowborder" style="vertical-align:top;">Fri</td>
</tr>
<tr class="row">
<td class="entry nocellnorowborder" style="vertical-align:top;">Hour in day (01-12)</td>
<td class="entry nocellnorowborder" style="vertical-align:top;">hh</td>
<td class="entry cell-norowborder" style="vertical-align:top;">3</td>
</tr>
<tr class="row">
<td class="entry nocellnorowborder" style="vertical-align:top;">Hour in day (1-23)</td>
<td class="entry nocellnorowborder" style="vertical-align:top;">HH</td>
<td class="entry cell-norowborder" style="vertical-align:top;">15</td>
</tr>
<tr class="row">
<td class="entry nocellnorowborder" style="vertical-align:top;">Minutes</td>
<td class="entry nocellnorowborder" style="vertical-align:top;">MI</td>
<td class="entry cell-norowborder" style="vertical-align:top;">18</td>
</tr>
<tr class="row">
<td class="entry nocellnorowborder" style="vertical-align:top;">Seconds</td>
<td class="entry nocellnorowborder" style="vertical-align:top;">SS</td>
<td class="entry cell-norowborder" style="vertical-align:top;">25</td>
</tr>
<tr class="row">
<td class="entry nocellnorowborder" style="vertical-align:top;">Millisecond (000-999)</td>
<td class="entry nocellnorowborder" style="vertical-align:top;">MS</td>
<td class="entry cell-norowborder" style="vertical-align:top;">0</td>
</tr>
<tr class="row">
<td class="entry row-nocellborder" style="vertical-align:top;">Meridiem indicator (AM or PM)</td>
<td class="entry row-nocellborder" style="vertical-align:top;">AM</td>
<td class="entry cellrowborder" style="vertical-align:top;">PM</td>
</tr>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
<div aria-labelledby="ariaid-title11" class="topic nested1" id="topic_dmy_4lf_dhb">
<h2 class="title topictitle2" id="ariaid-title11">Numeric functions</h2>
<div class="body">
<p class="p">These functions enable you to perform a wide range of mathematical calculations on
the information in your reports.</p>
<table border="1" cellpadding="4" cellspacing="0" class="simpletable" id="topic_dmy_4lf_dhb__simpletable_rwf_cmf_dhb" summary="">
<col style="width:50%">
<col style="width:50%">
<thead></thead>
<tbody>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">Function</td>
<td class="stentry" style="vertical-align:top;">Description</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">ABS<em class="ph i">(_number)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the absolute value of the supplied number.
<p class="p">Examples:</p>
<p class="p">The absolute value of <strong class="ph b">1</strong> is <strong class="ph b">1</strong></p>
<p class="p">The
absolute value of <strong class="ph b">-7.3</strong> is <strong class="ph b">7.3</strong></p>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">BETWEEN<em class="ph i">(_number,_number,_number)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns TRUE if the first supplied number is between the two other
numbers.<p class="p">Example:</p>
<p class="p">BETWEEN(SUM(Profit),500,1500) returns TRUE if
SUM(Profit) is equal to, or between 500 and 1500.</p>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">CEIL<em class="ph i">(_number)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the ceiling of the supplied number. The ceiling of a number is
its highest closest or equal integer.<p class="p">Examples:</p>
<p class="p">The ceiling of 125.4
is 126</p>
<p class="p">The ceiling of -63.2 is -63</p>
<p class="p">CEILING(SUM(First
resolution time (min))) returns the highest closest integer to each
first resolution time stored in the attribute.</p>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">EXP<em class="ph i">(_number)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the value of the base of the natural logarithm (e) to the power
of the supplied exponent.<p class="p">Example:</p>
<p class="p">EXP(SUM(Unit price)) returns the
natural logarithm of each value of the SUM (Unit price)
metric.</p>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">FLOOR<em class="ph i">(_number)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the floor of the supplied number. The floor of a number is its
lowest closest or equal integer. <p class="p">Examples:</p>
<p class="p">The floor of 125.4 is
125</p>
<p class="p">The floor of -63.2 is -64</p>
<p class="p">FLOOR(SUM(First resolution
time (min))) returns the lowest closest integer to each first resolution
time stored in the attribute.</p>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">INTEGER<em class="ph i">(_param)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the integer of the supplied non-integer
number.<p class="p">Example:</p>
<p class="p">INTEGER(1.56) returns 1</p>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">IS_NUMBER<em class="ph i">(_param)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns TRUE if the given parameter is a number (integer or decimal)
and FALSE if it isn’t. <p class="p">Examples:</p>
<ul class="ul" id="topic_dmy_4lf_dhb__ul_rxw_2xc_p1c">
<li class="li">IS_NUMBER(“-1234.987”) returns TRUE</li>
<li class="li">IS_NUMBER(“West”) returns FALSE</li>
</ul>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">MAXIMUM<em class="ph i">(_number,_number)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the largest of the two supplied
parameters.<p class="p">MAXIMUM(SUM(Revenues),SUM(Expenses)) returns the larger of
Revenues and Expenses.</p>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">MINIMUM<em class="ph i">(_number,_number)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the smallest of the two supplied
parameters.<p class="p">MINIMUM(SUM(Revenues),SUM(Expenses)) returns the smaller
of Revenues and Expenses.</p>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">NUMBER<em class="ph i">(_param)</em>
</td>
<td class="stentry" style="vertical-align:top;">
<p class="p">Returns the number representation of the given parameter, or returns NaN
when it cannot be displayed as a number. </p>
<p class="p">Examples:</p>
<p class="p">NUMBER("3.14116") returns 3.14116</p>
<p class="p">NUMBER ([Box category]) returns the number of the current value of the
Box category attribute.</p>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">PI<em class="ph i">()</em>
</td>
<td class="stentry" style="vertical-align:top;">
<p class="p">Returns the mathematical constant for the ratio of the circumference of a
circle to its diameter, expressed as PI. The value is
3.141592653589793.</p>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">POWER<em class="ph i">(_number,_number)</em>
</td>
<td class="stentry" style="vertical-align:top;">Computes and returns the first supplied number to the power of the
second supplied number.<p class="p">Example:</p>
<p class="p">IF SUM(Unit Price)=2 then
POWER(SUM(Unit Price),3) returns 8</p>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">RANDOM<em class="ph i">()</em>
</td>
<td class="stentry" style="vertical-align:top;">
<p class="p">Returns a pseudo-random number 'n' where 0&lt;=n&lt;1. If you need a
random integer, use the formula Round(Random()*100).</p>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">ROUND<em class="ph i">(_number)</em>
</td>
<td class="stentry" style="vertical-align:top;">
<p class="p">Rounds the value of supplied number up or down to the nearest integer. If
equidistant, the value is rounded up.</p>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">SIGN<em class="ph i">(_number)</em>
</td>
<td class="stentry" style="vertical-align:top;">
<p class="p">Returns -1 if the number is negative, 0 if zero, and 1 if positive.</p>
</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">SQRT<em class="ph i">(_number)</em>
</td>
<td class="stentry" style="vertical-align:top;">Computes and returns the square root of the supplied number.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">SQUARE<em class="ph i">(_number)</em>
</td>
<td class="stentry" style="vertical-align:top;">Computes and returns the square of the supplied number.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">LN<em class="ph i">(_number)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the natural logarithm of the supplied number.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">LOG10<em class="ph i">(_number)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the Base-10 logarithm of the supplied number.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">LOG2<em class="ph i">(_number)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the Base-2 logarithm of the supplied number.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">LOG<em class="ph i">(_base,_number)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the logarithm of the supplied number to the supplied
base.</td>
</tr>
</tbody>
</table>
</div>
</div>
<div aria-labelledby="ariaid-title12" class="topic nested1" id="topic_pxj_rlf_dhb">
<h2 class="title topictitle2" id="ariaid-title12">Trigonometric functions</h2>
<div class="body">
<p class="p">These functions help you to create advanced formulas for measuring angles and
distances.</p>
<table border="1" cellpadding="4" cellspacing="0" class="simpletable" id="topic_pxj_rlf_dhb__simpletable_ybx_1mf_dhb" summary="">
<col style="width:50%">
<col style="width:50%">
<thead></thead>
<tbody>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">Function</td>
<td class="stentry" style="vertical-align:top;">Description</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">ACOS<em class="ph i">(_number)</em>
</td>
<td class="stentry" style="vertical-align:top;">Computes the arc cosine of the entered number, in radians.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">ASIN<em class="ph i">(_number)</em>
</td>
<td class="stentry" style="vertical-align:top;">Computes the arc sine of the entered number, in radians.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">ATAN<em class="ph i">(_number)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the value in radians of the angle with the tangent entered in
the parameter. The value returned is between negative PI/2 and positive
PI/2.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">ATAN2<em class="ph i">(_number,_number)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the angle of the point Y/X in radians when measured
counterclockwise from a circle's X axis (0,0 represents the center of the
circle). The return value is between positive PI and negative PI. Enter the
Y coordinate as the first parameter.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">COS<em class="ph i">(_number)</em>
</td>
<td class="stentry" style="vertical-align:top;">Computes the cosine of the entered number, in radians.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">DEGREES<em class="ph i">(_number)</em>
</td>
<td class="stentry" style="vertical-align:top;">Converts the given number from radians to degrees.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">RADIANS<em class="ph i">(_number)</em>
</td>
<td class="stentry" style="vertical-align:top;">Converts the given number from degrees to radians.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">SIN<em class="ph i">(_number)</em>
</td>
<td class="stentry" style="vertical-align:top;">Computes the sine of the entered number, in radians.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">TAN<em class="ph i">(_number)</em>
</td>
<td class="stentry" style="vertical-align:top;">Returns the tangent of the entered angle.</td>
</tr>
</tbody>
</table>
</div>
</div>
<div aria-labelledby="ariaid-title13" class="topic nested1" id="topic_kmv_2yd_y2c">
<h2 class="title topictitle2" id="ariaid-title13">Comment functions</h2>
<div class="body">
<p class="p">Use these operators to add comments to your formulas to explain how it works. This is
helpful if you want to collaborate on formulas with other users, or if you want to
make notes for yourself on why you built the formula the way you did.</p>
<table border="1" cellpadding="4" cellspacing="0" class="simpletable" id="topic_kmv_2yd_y2c__simpletable_my5_gyd_y2c" summary="">
<col style="width:50%">
<col style="width:50%">
<thead></thead>
<tbody>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">Operator</td>
<td class="stentry" style="vertical-align:top;">Description</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">/*</td>
<td class="stentry" style="vertical-align:top;">Marks the start of a comment.</td>
</tr>
<tr class="strow">
<td class="stentry" style="vertical-align:top;">*/</td>
<td class="stentry" style="vertical-align:top;">Marks the end of a comment.</td>
</tr>
</tbody>
</table>
<p class="p">Example: <code class="ph codeph">/* this is a comment in a formula */</code></p>
</div>
</div>
</body>