EIGENN.
docsguidesapichangelogpricingsign in
EIGENN.

Time settings

Set the granularity, the model date range, and the fiscal year of a planning model in Model settings.

The time settings set the periods of a model. Set them before you write formulas, because a formula runs one time for each period. A time reference such as [t-12] counts periods, so its meaning depends on these settings.

1. Open the time settings

  1. Go to Scenario planning → open a model.
  2. Select Model settings.

You can also select More → Time settings, or the gear button (Open model settings) at the top right. The panel opens on the right. The Data sources, Scenarios, and Sharing buttons at the top of the panel open other settings.

2. Set the granularity and the date range

  1. In Granularity, select Daily, Weekly, Monthly, Quarterly, or Yearly.
  2. Under Model date range, set the start date and the end date.
  3. Select Apply changes.

Eigenn moves each date to the start of its period. In a quarterly model, 15 August 2026 becomes 1 July 2026. The end date is the start of the last period. A monthly range from 1 January 2027 to 1 December 2027 has 12 periods. A model can have up to 1,200 periods.

When you add periods at the end, input variables are blank in the new periods. Formula variables calculate there. Eigenn does not remove a period that holds a stored value, such as a typed input. A new input has 0 in each period, and 0 is a stored value.

3. Set the fiscal year

  1. Turn on Use fiscal years.
  2. In Fiscal year starts in, select the first month of the fiscal year.
  3. Select Apply changes.

The fiscal year changes two formula keywords:

KeywordValueExample with an April start
fiscalmonthThe month of the fiscal year, 1 to 12April 2027 is 1. March 2027 is 12.
fiscalyearThe calendar year in which the fiscal year endsApril 2027 is 2028. March 2027 is 2027.

With Use fiscal years off, fiscalyear is blank and fiscalmonth is the calendar month.

4. Other settings in the panel

  • Last actual date: Sets where actuals stop. See Last actual date.
  • Use relative dates names each period column by its position: Month 1, Month 2, and so on. Start relative dates at 0 starts the count at Month 0. The count starts at the first model period. Quarter and year total columns keep their calendar names.
  • Highlight today marks the period column that contains today's date: the header is blue, and the cells have a light tint.
  • These display settings do not change values, formulas, or the Last actual date.

Messages

MessageCauseAction
The model end period must not precede the start period.The end date is before the start date.Change one of the dates.
The selected model range exceeds 1200 periods.The range has too many periods.Shorten the range or use larger periods.
Stored value variable (period) cannot be safely represented on the new axis.The change removes or splits a period that holds a stored value.Keep that period in the range.
The Last actual date must remain an exact model period when the axis changes.The change removes or changes the period of the Last actual date.Turn off Last actual date, apply, and then change the range.

When the change is saved, the panel shows "Time settings saved."

Related

  • Time
  • Time granularity
  • Last actual date
  • Time references
  • Configure Planning Time and Actuals

Time references

Read the previous period, a fixed period, a range of periods, or every period with square brackets after a variable name.

Time totals

The Time aggregation setting of a variable decides its quarter and year totals, such as a sum, an average, or the last value.

On this page

1. Open the time settings2. Set the granularity and the date range3. Set the fiscal year4. Other settings in the panelMessagesRelated

Eigenn docs

current product

Overview
Overview
OverviewAccount PreferencesApproval PoliciesAssistant AutomationAssistant Command CenterAssistant Workspace and Saved WorkBank ConnectionsBilling and UsageBudgets and ForecastCommand CenterCustomer FieldsCustomer LifecycleCustomer RecordsCustomersDeveloper PlatformDocument Processing and ExtractionFiles and Document VaultFinancial Analytics and ReportsFinancial OverviewInbox and ApprovalsInvoice InsightsInvoice ProductsInvoicesMarketplace IntegrationsNotifications and BrandingOnboarding and SupportOverviewPlanning Data and DimensionsPlanning Models and FormulasPlanning Time and ActualsPlanning UncertaintyPlanning Versions and CollaborationPlanning Views and ExportsPlans and AdjustmentsReceivablesReceivables AnalyticsReceivables ControlsRolling Budget CloseScenario PlanningSecurity and AccessSettings OverviewStress TestsTeams and OrganizationsTone Profiles and ExperimentsTransaction Categories and RulesTransaction CodingTransactionsWeekly Finance RitualWorkflow ExecutionsWorkflow OutcomesWorkflow PausesWorkflows
OverviewBudget vs. ActualsBuild a Driver-Based Planning ModelBuild and Review a ForecastBuild Your First WorkflowCollaborate on a Planning ModelCompare and Share Planning ScenariosConfigure Approval PoliciesConfigure Assistant OperationsConfigure Customer FieldsConfigure Notifications and BrandingConfigure Planning Time and ActualsConfigure Receivables ControlsConnect Planning Data and ActualsConnect Transaction RecordsConsolidationCreate and Manage CustomersCreate and Send InvoicesCreate Your First Planning ModelDeveloper API SetupFirst Cash ReviewHeadcount PlanningInvoice Collection WorkflowMaintain Transaction RulesManage Security and BillingManage Team AccessManage the Invoice LifecycleMCP WorkflowsMonitor and Recover WorkflowsOrganize and Share DocumentsProcess Inbox ItemsReconcile and Categorize TransactionsRevenue ForecastingReview a Customer Finance RecordReview, Restore, and Export a Planning ModelRun a Finance Operating ReviewRun a Receivables Tone ExperimentRun a Runway Stress TestRun Planning Uncertainty AnalysisRun Your First Command Center ReviewSave and Share Assistant WorkSet Up a WorkspaceTroubleshoot Account AccessWebhook DeliveryWeekly CFO Review
Overview

Concepts

DataDimensionsFormulasScenarios

Variables

VariablesChange an input over timeCreate a variableFormat a variableOrganize variablesTime totalsUse a variable from another modelVariable types

Time

TimeLast actual dateRoll the model forwardTime granularityTime settings

Formulas

FormulasBlanks and helpersCommon formulas: cash and balance sheetCommon formulas: cohortsCommon formulas: currency and multiple entitiesCommon formulas: headcount and payrollCommon formulas: SaaS metricsCommon formulas: seasonalityConditionalsDimension referencesFormula syntaxFunctionsTime referencesTroubleshoot formulasValues with uncertaintyWrite a formula

Charts and Dashboards

Charts and dashboardsCompare scenarios and versionsCreate a chartExport and shareTablesTime aggregation in charts

Dimensions

DimensionsApply a dimensionCreate a dimensionDimension examplesDimension totalsThe Dimensions page

Data

DataChoose cash or accrual for XeroConnect a data sourceLink a variable to dataRefresh and check actualsUse transaction categories as actuals

Data Integrations

Data integrationsBank transactionsCSV importFortnoxQuickBooksStripeXero

Views

ViewsCreate and edit a viewFilter a viewShare a view

Versions

VersionsCompare versionsRestore a versionSave a version

Scenarios

ScenariosCompare scenariosCreate a scenarioPlans and adjustmentsStress tests and shocks

Collaboration

CollaborationComment on a modelShare a model and set accessTeam roles and planning access

Managing Models

Managing modelsDuplicate a modelExport a modelModel limits and performanceStart from a templateThe models home and foldersTrash, restore, and delete a model
OverviewIntegrationsMCPSDKsWebhooks
OverviewAuthenticationBank Accounts APICustomers APIErrorsForecasts and Stress Tests APIInvoice Payments APIInvoices APIPaginationRate LimitsRemote Tracker API StatusTracker Categories APITracker Entries and Timers APITracker Projects APITransactions APIWebhooks API StatusWorkflows API
Overview
Overview