Knowledge Base Article

Excluding Data That Isn't Fully Baked

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
Updated 03-02-2023
No CommentsBe the first to comment