VALUEWORKSInsights to Results
Sign in
Help center
Core path

Choosing the period

Set the statement to the period the question is about.

The columns aren't fixed at twelve months — that's just one setting.

The date picker offers six granularities: Month, Quarter, Half-Year, Year, LTM and Custom, alongside a list of years.

The choice decides the columns. Ask for a year and you get months across the table; ask for Quarter and you get quarters. LTM — the last twelve months — is the one people reach for least and need most, because it rolls with the calendar instead of restarting every January.

Custom takes an arbitrary start and end, for the periods that don't fit a calendar: a funding round, a campaign, the months since a new pricing model launched.

Arrows either side of the picker step forward and back a period at a time.

Screenshot 2.3.1: The six granularities, Year list, Step arrows.
  1. 1The six granularities
  2. 2Year list
  3. 3Step arrows

ValueWorks 2026.08

Try this in your tenant — put the same statement on Year and then on LTM, and see which months move.

Takeaways

  • Six granularities: Month, Quarter, Half-Year, Year, LTM, Custom.

  • The granularity decides the columns — nothing about twelve months is fixed.

  • LTM rolls with the calendar instead of restarting in January.

Surfaces covered

  • Reporting
  • Financial Reporting

Also taught in the Academy

Module 2 · Financial Reporting

Take it as lesson 2.3 in Business Analyst & FP&A