Set Analysis with Inputbox or prompt

[#1]

Hi ,

I have a requirement where as we want to exclude certain ticketids from the SLA Calculation. It should work in this way. It should prompt for the Ticketid that should be excluded. It can be multiple Ticketids.

Is it possible to do with the SET Modifiers.

Normally the formula will be (sum(Tickets within SLA)/Sum(Closed Tickets))*100.

Regards,XXX

[Miguel_Angel_Baeyens]

Hello,

As inputboxes work with variables, you may use something like

(Sum({< TicketdID = {'$(vVariable)'} >} Field) / Sum(Closed Tickets))*100

Is that what you are looking for?

[#3]

Hi Miguel,

Thanks for your response. Yes it was i am looking but small change in that whatever ticketid i am passing through the Input boxes should be excluded and remaining tckets should be counted.

Regards,XXX

[Miguel_Angel_Baeyens]

Hi,

Not knowing your data model, could it be something like

(Sum({< TicketdID -= {'$(vVariable)'} >} Field) / Sum(Closed Tickets))*100

Note the minus sign before the equal, the -= operator meaning "all but the following"

[#5]

Hi Miguel,

The Query i am using Currently is

SUM(IF((CTA=0 and RPS<=100 AND SUS>3),1,0))/SUM(IF((CTA=0 and RPS<=100 AND SUS>3),1,0))

and i am trying to modify based on ur suggestion

I have few queries as

Can the variables can have multiple values (Comma seperated values)?

Regards,XXX

[Miguel_Angel_Baeyens]

XXX wrote:Can the variables can have multiple values (Comma seperated values)?

Yes, you can create a variable in script or using CTRL + ALT + V such in

SET vVariable = 1, 2, 3, 4;

If there are no constraints set in your inputbox, you can enter

1, 2, 3, 4

and so it will be stored in the variable.

When you use it in set analysis, it will work in my example above.

Your expression might look like

Sum({< CTA = {0}, RPS = {'<=100'}, SUS = {'>3'} >} 1) / Sum({< CTA = {0}, RPS = {'<=100'}, SUS = {'>3'} >} 1)

written in set analysis form, although I'm guessing you are trying to count (sum 1) rather than sum.