Have a dataset where you want to display everything but the most recent time period? This is handy to do if you want to only disclose KPIs once data has been given the chance to fully mature. (For example, If we're in the middle of Q4, I only want to show data for Q1,Q2, and Q3!)
select
[created_at:aggregation]
, count(*) as KPI
from
table
where
[created_at:aggregation]!=[getdate():aggregation]
group by
1
