Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

removal of hard code in the set expression

hi,

Can anyone help me to modify the set expression by removal of hard code.

This expression counts the number of promoters whose CSAT overall score >=3 and the same expression has to be modified by using [ResolvedTicket.CSAT Overall Score] >= CSAT_Promotors_Max and [ResolvedTicket.CSAT Overall Score]<=CSAT_Promotors_Min,

=count({$<[Common Ticket Type]={'INCIDENT'},

[Common Status]={'Resolved','Closed'},

[ResolvedTicket.CSAT Overall Score]={">=3.00"},

ResolvedTicket.InAMSScope={'-1'}>}ResolvedTicket.TicketID)

Am unable to get the solution. please find the attached for your reference.

please help me to modify the expression.

Thanks in advance.

Smitha

5 Replies
stigchel
Partner - Master
Partner - Master

I'm guessing that this is an example of what you are looking for:

[ResolvedTicket.CSAT Overall Score] >= $(=CSAT_Promotors_Max)


$(=   ) --> This is called Dollar-Sign Expansion (look in the help)


Not applicable
Author


hi,

I need an expression to get the value which lies in the range Promters max and Promoters min.

Below is the expresssion which needs to be modified.

[ResolvedTicket.CSAT Overall Score] >= CSAT_Promotors_Max and [ResolvedTicket.CSAT Overall Score]<=CSAT_Promotors_Min,

Please find the attached xls for the reference.

Thanks in advance,

Smitha

Not applicable
Author

hi, 

I need an expression to get the value which lies in the range Promters max and Promoters min.

Below is the expresssion which needs to be modified.

[ResolvedTicket.CSAT Overall Score] >= CSAT_Promotors_Max and [ResolvedTicket.CSAT Overall Score]<=CSAT_Promotors_Min,

Please find the attached xls for the reference.

Thanks in advance,

Smitha

MayilVahanan

HI

Try like this

=count({$<[ResolvedTicket.CSAT Overall Score] = {'>=$(=CSAT_Promotors_Max) <= $(=CSAT_Promotors_Min)'},

[Common Status]={'Resolved','Closed'},

[ResolvedTicket.CSAT Overall Score]={">=3.00"},

ResolvedTicket.InAMSScope={'-1'}>}ResolvedTicket.TicketID)

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

hi,

thank you so much for the solution, it worked fine.

Regards,

Smitha