Timeframe to allow last_n_items

[itayw]

var table1Query = {
    timeframe: 'last_15_items',
    interval: 'second',
    dimensions: [
      {key: 'flows.name', name: 'Flow name', collection: 'benchmark'}
    ],
    metrics: [
      {
        key: 'reqrate',
        name: 'Avg. Request Time',
        formula: {
          dependsOn: [
            {
              key: 'req-count',
              aggregation: 'avg',
              dependsOn: 'flows.main.meter.count'
            },
            {
              key: 'elapsed',
              aggregation: 'avg',
              dependsOn: 'flows.totalElapsed'
            }
          ],
          run: 'function(count, elapsed){return elapsed/count}'
        },
        decimals: 4,
        suffix: 'ms'
      }
    ],
    collection: 'benchmark'
  };

[orweinberger]

The last_n_items does not seem to work when dimension is set to timestamp. This is what I'm trying to run:

joolaio.query.fetch({
  timeframe:'last_1_items',
  interval: 'second',
  dimensions: [{key:'timestamp', collection:'VoyGXTIeTpxzAmnj8H'}],
  collection: 'VoyGXTIeTpxzAmnj8H',
  metrics: [{key:'visits', collection:'VoyGXTIeTpxzAmnj8H'}],
  filter: null
}, function(err, results) {
  if (err)
    throw err;
  console.log(results);
});

I get a result with 1 document. The timestamp in the single document is the current time and the value is 0.

I would basically like to get the last time an item was inserted.

[itayw]

Will setting filter to filter: [] or removing it from the query changes the result?

[orweinberger]

Nope, same result.