Explore recipe: Combining zero agent replies into the one reply bracket

Suite Professional, Enterprise, and Enterprise Plus Explore Professional only

This recipe shows you how to combine zero agent replies into the one agent reply bracket when using theAgent replies bracketsattribute.

What you'll need

技术水平:Moderate

Time Required:10 minutes

Open a report that uses theAgent replies bracketsattribute, for example,Explore Recipe: Percentage satisfaction score based on agent replies.
In the report builder, click the calculations icon () on the right sidebar and clickStandard calculated attribute.
On theStandard calculated attributepage, enter aNamefor the attribute (for exampleLB Agent replies brackets), and then enter the following formula:
```
IF(VALUE(Agent replies)=0)
THEN "1"
ELIF (VALUE(Agent replies)=1)
THEN "1"
ELIF(价值(代理回复)= 2)
THEN "2"
ELIF (VALUE(Agent replies)>2 AND VALUE(Agent replies)<=5)
THEN "3-5"
ELIF (VALUE(Agent replies)>5)
THEN ">5"
ELSE "0"
ENDIF
```
Tip:If you're working in a language other than English,read this articleto help you enter Explore formulas in your language.
ClickSave.
In theColumns panel, click添加.
From the list of attributes, choose the custom attribute you createdLB Agent replies brackets.

You will no longer see a bracket for 0 replies because it is merged within the 1 reply bracket: