1 Reply Latest reply: Aug 31, 2011 1:11 AM by Liron Baram RSS

    Get Last Record within TimePeriod

    Brian VanderZanden

      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.

       

      DeviceTypeDeviceCountMonthYrTestedPassed
      Pipe2Jan-201111
      Pipe1Feb-201110
      Vent2Jan-201121
      Vent2Feb-201111