a function for "incidents which is in progress more than 10 days"

[#1]

hi

i am trying to take the number of incidents which is in progress more than 10 days... "in progress" sate is in the status table and i take the incident count from the incident table,, can some one tell me how to get this calculation plz

thank you in advance

[#2]

would you be able to share a qvw or some sample data?

[#3]

i have attached my qvw.. hear i want to take the total number of incidents which is in pending state more than to day..

[fkeuroglian]

hi, i suppose you have a date for each incident? in this case you could use DateDiff or Interval Match Functions to calculate the amount of days that each incident have.

in your expression you could use something like:

if(today()  - dateIncident)>9, red(),green()) in the format color in expression

please put and example qvw to be easier help you

Fernando

[Anonymous]

Hi,

The following attachment might help you....

[#6]

hi

i have attached an example above.. i need to take a count of all the in progress incidents more than 10 days. is there a possible way??

[#7]

hi Venkata

i am using a personal edition so i am unable to open your attachment will it be possible for you to send me some screen shots plzzz ???