I have QV-application with info about Service Desk work.
1) table with next fields: "Assignee", "Count of incidents resolved during 1 day", "Count of incidents resolved during 1 week", 1 month, etc.
2) additional table with info about percentage.
3) table with info about average time of resolving for each of fields
So there are 2 dates for each incident: Reported_time and Resolved_time. And time of resolving process = Resolved_time - Reported_time.
My problem is
I do not understand how to work correctly with such operation as "Resolved_time - Reported_time" or "if (Resolved_time - Reported_time) >0 and (Resolved_time - Reported_time)<1), count (Incident_ID)" during the loading or how to make it as condition in expression (in table)
For example xls are attached. One is real data I have (Resolved_time is [Resolved.TIME]
[Resolved.TIME]- Reported_time is
And another is about my tasks.
Thanks a lot for your help!