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.