TABLE OF CONTENTS
You can create attributes of your choice and use them in filters or group-by to further organise or drill down your data using Custom Attributes.
Navigation:
- Goto Analytics tab from your left menu
- Click the Settings icon on the top-right corner
- Select “Custom Attributes” from the side menu
- Click on “Create Attribute” in the top right corner to start creating your custom metrics by using a combination of functions or operators.
- Click “Save Attribute” once done
- Use this custom attribute to view the metrics the way you would like to
Create your own Attributes and Group by
You can use the following functions to create your own Attributes and group-by.
COMMAND | MEANING |
Function - Date | |
fx DATEDIFF_SECONDS | Returns the difference between X and Y in seconds, X being the later date and Y being the earlier date |
fx DATEDIFF_MINUTES | Returns the difference between X and Y in minutes, X being the later date and Y being the earlier date |
fx DATEDIFF_HOURS | Returns the difference between X and Y in hours, X being the later date and Y being the earlier date |
fx DATEDIFF_DAYS | Returns the difference between X and Y in days, X being the later date and Y being the earlier date |
fx DATEDIFF_WEEKS | Returns the difference between X and Y in weeks, X being the later date and Y being the earlier date |
fx DATEDIFF_MONTHS | Returns the difference between X and Y in months, X being the later date and Y being the earlier date |
fx DATEDIFF_YEARS | Returns the difference between X and Y in years, X being the later date and Y being the earlier date |
fx SECOND | Returns X with seconds as the unit |
fx MINUTE | Returns X with minutes as the unit |
fx HOUR | Returns X with hours as the unit |
fx DAY | Returns X with days as the unit |
fx MONTH | Returns X with months as the unit |
fx YEAR | Returns X with years as the unit |
| Function - Number | |
fx CEIL | Returns the least integer greater than or equal to X Example CEIL (2.5) is 3 |
fx FLOOR | Returns the largest integer lesser than or equal to X Example FLOOR (2.5) is 2 |
fx ROUND | Round the number up to the nearest integer value. Example ROUND (2.5) is 3 |
fx EXP | Returns the value of e (Euler's number) to the power of X Example EXP (2) is 7.38906 |
fx GREATEST | Returns greatest value among all fields Example GREATEST (1, 2, 3) returns 3 |
fx LEAST | Returns least value among all fields Example LEAST (1, 2, 3) returns 1 |
| fx LN | Returns the value of natural logarithm function of X (base e logarithm of X) Example LN (2) is 0.6931471805599453 |
fx POWER | Returns the value of X to the power of Y Example POWER (2, 3) will return 8 |
fx SQRT | Returns the value of the square root of X. Example SQRT (4) will return 2 |
| Function - String | |
fx CONCAT | Returns a string that is basically X1, X2, X3 strung together. Example CONCAT (Down, To, Boogie) will return 'DownToBoogie' as a value |
fx LEFT | Returns a string that starts from a number of characters (n) from the beginning of X. Example LEFT (STRING, 1) will return 'TRING' |
| fx RIGHT | Returns a string that starts from a number of characters (n) from the end of X. Example RIGHT (STRING, 1) will return G |
| fx LENGTH | Returns the number of characters in X Example LENGTH (STRING) will return 5 |
| fx LTRIM | Returns the string X with leading spaces removed Example LTRIM ( STRING) will return 'STRING' |
| fx RTRIM | Returns the string X with trailing spaces removed Example RTRIM (STRING ) will return 'STRING' |
| fx LPAD | Returns the string with empty leading space padding on the left, based on the given length. Example LPAD(STRING, 2) will return ' STRING' |
| fx RPAD | Returns the string with empty trailing space padding to the right, based on the given length. Example RPAD (STRING, 2) will return 'STRING ' |
| fx REPEAT | Returns the string X repeated n times. Example REPEAT (STRING, 2) will return 'STRINGSTRING' |
| fx REVERSE | Returns the string X in reverse. Example REVERSE (STRING) will return 'GNIRTS' |
| fx SUBSTRING | Returns a substring of X, beginning from position 'n' - counted from left to right. Example SUBSTRING (STRING, 2) will return 'RING' |
| fx TRIM | Returns X with leading and trailing whitespace removed Example TRIM ( STRING ) will return 'STRING' |
| Function - Logical | |
fx BETWEEN | Returns 1 if X is between Y and Z Example BETWEEN (2, 1, 3) will return 1 |
fx NOTBETWEEN | Returns 1 if X is not between Y and Z Example NOTBETWEEN (1, 2, 3) will return 1 |
fx ISNULL | Returns 1 if X is null, else 0 Example ISNULL (CLOSE DATE) |
fx ISNOTNULL | Returns 1 if X is not null, else 0 Example ISNOTNULL (CLOSE DATE) |
Function - Operators | |
+ | Addition |
| - | Subtraction |
| * | Multiplication |
| / | Division |
| % | Modular Division |
Sample metrics for you to get started:
Defining a custom resolution time which is the time taken from the ‘assigned’ stage to the ‘resolved’ stage. Ticket resolution by the bot is L0 and we do not want to take that into consideration.
Formula: datediff_hours(resolved date, created date)