Time Range Calculations and Trends

  • Kathi Kellenberger
  • Clayton Groom
Chapter

Abstract

A common reporting requirement is to produce totals by different ranges of time for comparison. Typical reports contain totals by month, quarter, and year, sometimes with comparisons to the same period in the prior year or for month-to-date or year-to-date totals. Products like SQL Server Analysis Services and PowerPivot provide functions to navigate date hierarchies. With window functions in SQL Server 2012 or later, you can produce the same calculations using the techniques provided earlier in this book.

Keywords

Window Function Single Query Input Calculation Base Query Column Calculation 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Copyright information

© Kathi Kellenberger with Clayton Groom 2015

Authors and Affiliations

  • Kathi Kellenberger
    • 1
  • Clayton Groom
    • 1
  1. 1.ILUnited States

Personalised recommendations