Supported data formats for measures in custom views

Last Updated : Jun 24, 2022 |
When creating or editing a custom view, you can specify the format in which you want to present the measure data in the custom view.
For example, if a measure contains timestamp type of data, you can specify the date and time format in which the data should appear in the custom view.
The following table provides the list of supported data formats that you can use to present the data in a custom view. The data format options that are available for a measure depend on the data type of the measure.
Data format option is not available for measures that contain numeric data.
Prolog information
Metadata
Keywords:
Data type of the measure
Available data formats
String (characters)
The following are the data format options for measures that contain data in string format:
  • Lowercase: To present the data in lowercase.
  • Uppercase: To present the data in uppercase.
  • Trim: To present the data after removing the extra spaces at the beginning and end of the data.
  • None: To present the string data in its original format.
Example measures that contain string data type are: Campaign Name and Organization measures of Active Campaigns.
Floating point numbers (percentage)
The following are the data format options for measures that contain percentage data:
  • No decimal place: If you want to round off the percentage to an integer without any decimal points.
  • Single decimal place: If you want to round off the percentage to a single decimal point.
  • Two decimal places: If you want to round off the percentage to two decimal points.
  • None: To present the percentage data in its original format.
Example measures that contain percentage data are: Off Job Idle (%) and Off Job Break (%) measures of Staffed Agents.
Date and time
The following are the data format options for measures that contain date and time data:
  • DD/MM/YYYY HH:mm:ss: To present the date in DD/MM/YYYY format and time in a 24-hour format.
  • DD/MM/YYYY hh:mm:ss a: To present the date in DD/MM/YYYY format and time in a 12-hour format.
  • YYYY/MM/DD HH:mm:ss: To present the date in YYYY/MM/DD format and time in a 24-hour format.
  • YYYY/MM/DD hh:mm:ss a: To present the date in YYYY/MM/DD format and time in a 12-hour format.
  • None: To present the date and time data in its original format.
Example measures that contain date and time data are: Start Time and Estimated End Time measures of Active Campaigns.
Duration
The following are the data format options for measures that contain duration data:
  • ss: To present the duration data in seconds.
  • mm:ss: To present the duration data in minutes and seconds.
  • None: To present the duration data in its original format.
Example measures that contain duration data are: Inbound Duration and Outbound Duration measures of Staffed Agents.
Related links
Create / Edit View page field descriptions