How to filter out rows for individual tables by Metric date?

[minkyuk]

Hello,

I have a handful of tables that contain monthly reported data. Each table starts at a different Metric time, meaning table 1 starts the report 2015/1/1 while table 2 could be starting on 2015/3/1.

I am trying to filter out every first two rows from each table. I could manually go through every table and put

|where metric_date < ****** 

but I feel like there should be a way to automate this process.

Can anyone help if you have any idea?

Thank you ahead,
J

[jeffland · Accepted solution]

Doesn't the head function do exactly what you need? See docs here.

[minkyuk]

Hi.. sorry for the late accept.
head is the function I was kind of looking for, but how could I exclude the first rows instead of returning them?

[jeffland]

AFAIK, there's no "official" way to do it.
I've only ever been able to do this with | streamstats count as c | where c>10 (hardly any performance impact).