'output (expected):
other  value
2014-01-01    NaN      2
2014-01-02      1      3
2014-01-03      2      3'

def test_id_take_last_in_group_macro(self):

    T = pd.Timestamp
    df = pd.DataFrame(columns=['asof_date', 'timestamp', 'other', 'value'], data=[[T('2013-12-31'), T('2013-12-31    01'), np.nan, 1], [T('2013-12-31'), T('2013-12-31    02'), np.nan, 2], [T('2014-01-01'), T('2014-01-01    01'), 1, np.nan], [T('2014-01-01'), T('2014-01-01    02'), np.nan, 3], [T('2014-01-02'), T('2014-01-02    01'), 2, np.nan], [T('2014-01-02'), T('2014-01-02    02'), np.nan, np.nan]])
    fields = OrderedDict(self.macro_dshape.measure.fields)
    fields['other'] = fields['value']
    expected = pd.DataFrame(data=[[np.nan, 2], [1, 3], [2, 3]], columns=['other', 'value'], index=self.dates)
    self._test_id_macro(df, (var * Record(fields)), expected, self.asset_finder, ('other', 'value'))
