removal of hard code in the set expression

[#1]

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

[stigchel]

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)

[#3]

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

[#4]

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)

[#6]

hi,

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

Regards,

Smitha