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
1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • That's pretty handy! I'll have to try this out

    Reply Like 1
Like1 Follow
  • 1 Likes
  • 1 yr agoLast active
  • 1Replies
  • 488Views
  • 2 Following