Get Last Record within TimePeriod

[bvanderzanden]

I have a data set which consists of device inspections where they can inspect a device multiple times during a month.

Only the last test matters as they are the aggregate results of all of the tests.

I need to be able to sum up by time period (Month/Year) how may devices were tested (tested=1) and passed (passed=1).

I've attached a sample qvw with some data already loaded.

The desired result would be to have by Device Type the number of tested and passed devices by Period.

DeviceType	DeviceCount	MonthYr	Tested	Passed
Pipe	2	Jan-2011	1	1
Pipe	1	Feb-2011	1	0
Vent	2	Jan-2011	2	1
Vent	2	Feb-2011	1	1

[lironbaram · Accepted solution]

hei

attach is an example

look at the script

most of the work is there

as in the script , you put a flag on the last testy in the month for any device

from there the expressions are quite regular aggr function with set analysis