Difference between date

[canmarroig]

Hi, i need to represent time how many tickets have been solved the last month, within x days (a variable called vDatSet) from support request and time to solve problem.

I've tried to :

if((date([Solution])-date([OpenTicket]))<=$(vDaySet),count(distinct ID_Ticket))

but I dont' understand how set date on last month and how match set analysis and if condition.

Help me pls.

Can

[m_woolf · Accepted solution]

Try:

count(distinct if((date([Solution])-date([OpenTicket]))<=$(vDaySet),ID_Ticket))

[jonathandienst]

Assuming Solution and OpenTicket are true (numeric) date fields and vDaySet is a number, then this should work:

=Count(If(Solution - OpenTicket <= vDaySet, Distinct ID_Ticket))

[Mark_Little]

Hi,

Another possibly approach would be to add a days to resolve field in the script.

then Count({<DaystoResolve={'<=$(vDaySet)'}>}Distinct ID_Ticket)

Mark

[jonathandienst]

If that does not work, it may be that your "date" fields are actually strings and/or mat contain a date component.

Sum(If()) expressions can perform poorly on large data sets, so you may want to create a derived variable, something like this:

LOAD

     ...

     Solution - OpenTicket As Offset,

     Solution,

     OpenTicket,

     ...

Then you can use a set expression (which should perform much better):

Count{<Offset = {"<=$(vDaySet)"}>} Distinct ID_Ticket)

For more detailed help, please upload a representative sample qvw file.