LogoLogo
HomepageWhat's NewLoginContact Us
  • Start the Journey
  • Introduction to JustPerform
  • What's new
    • April 2025
    • March 2025
    • February 2025
    • January 2025
    • December 2024
    • November 2024
    • October 2024
    • September 2024
    • August 2024
    • July 2024
    • June 2024
    • May 2024
    • April 2024
    • March 2024
    • February 2024
    • December 2023
    • November 2023
    • October 2023
    • September 2023
    • July 2023
    • June 2023
    • May 2023
    • April 2023
    • March 2023
    • February 2023
    • January 2023
    • December 2022
    • November 2022
    • October 2022
      • About Spaces
      • About Drive
      • About Modelling
      • About Governance
  • Getting Started
    • Log In
      • Get Access
      • Reset Password
    • Navigate
    • My Support
      • Get Access
      • Navigate
        • How-To Raise
        • How-To Assign
  • Process Definition
    • Modelling
      • Key Components
      • App
        • Navigate
        • How-To Guide
      • Fields
        • Key Terms
        • Navigate
        • How-To Guide
      • Functional Area
        • Navigate
        • Functional Area Detail
        • How-To Guide
      • Sheets
        • Navigate
        • Sheet Detail
          • Level 2 Header
          • Sheet Details Header
          • Layout
          • Options
          • Fields
        • Metrics
          • Navigate
          • Metric Details
        • How-To Guide
      • Models
        • Standard Model
          • How-To Guide
        • Virtual Model
          • How-To Guide
        • Advanced Models
        • Review Data
          • Features
      • Transactions
        • Journal
        • How-To Guide
      • Consolidation Features
        • Consolidation Sheet
        • How-To Guide
    • Process
      • Navigate
      • How-To Guide
      • Scenarios
        • How-To Guide
      • Flow
        • General
        • Navigate
        • How-To Guide
      • Cycle
        • Navigate
        • How-To Guide
        • My Activities
    • Calculations
      • Account Reclassification
        • Navigate
        • How-To Guide
      • Allocation
        • Navigate
        • How-To Guide
      • Account Mapping
        • Navigate
        • How-To Guide
      • Intercompany Elimination
        • Navigate
        • How-To Guide
      • Automatic Journal
        • How-To Guide
      • Currency Conversion
      • Value Driver Tree
        • Get Access
        • Navigate
        • Options
        • How-To Scenarios
          • Lookup - Same Module
          • Lookup - Different Module
          • Union
          • Time Offset
          • Functions
    • Permissions
      • Access Review
        • Navigate
      • Users
        • Navigate
        • How-To Guide
      • Role Management
        • Navigate
        • How-To Guide
    • Remote Tables
      • Files Connection
        • What's the User Flow
        • What's in Connection Schema
        • How-To Guide: By Sheet
        • How-To Guide: Multiple Sheet
        • How-To Guide: Different Sheets
    • Data Flow
      • Navigate
      • Dataflow Details
  • JustPerform 365 Connector
    • Introduction
    • Get Access
    • Navigate
      • Activities Pane
      • Explore Pane
      • Home Pane
  • Stories
    • Getting Started
    • Excel Stories
      • Stories - Design Pane
        • Header
        • Definition
        • Layout
        • Options
      • Create Stories
        • How-To Guide
        • How-To Access Stories
        • How-To Run Calculation
        • How-To Submit Workflow
      • Styles
        • How-To Guide
      • Functions
        • How-To Guide
      • Parameters
        • User flow
        • How-To (User Context)
        • How-To (Book Context)
      • Time series
      • Advanced
    • Snippets
      • Navigate
      • Types of Snippets
      • Design Pane
        • Level 2 Header
        • Snippet Header
        • Layout
        • Options
        • Fields
        • Visual
        • Styles
      • How-To Guide
        • Reports
        • Visuals
        • Input
    • Board
      • Navigate
      • How-To Guide
  • Advanced
    • Connections
      • Connection to S/4 HANA
        • How to Set Up ODP
      • Success Factor
    • Monitoring
      • Task Monitor
        • Actions
      • Event Log
        • Actions
    • General
      • Password Policy
      • Multi Language Localization
        • Enable Multi Language
        • Set Preferred Language
Powered by GitBook
On this page
  • Year to date
  • Month to date
  • Half-year to date
  • Quater to date
  • Balances
  1. Stories
  2. Excel Stories

Time series

JustPerform Canvas Add-in provides the functionality using which users can view the data in the following forms

  • Year to date

  • Month to date

  • Half-year to date

  • Quarter to date

  • Balances

The above functionalities can be used for Assets, Liabilities, Income and expenses.

Year to date

The year to date functionality helps the users to retrieve the data from the starting of the year till the current period of the year. For example, if the user is currently in July month and wants to know the revenue they generated till July so the user can select year to date to get the total revenue they generated from January till July.

Month to date

The month to date functionality helps the users to retrieve the data from the starting of the month till the current date of the month. For example, if the user is currently on the 20th day of the month and wants to know how much expense they occured till today for the month so the user can select the month to date functionality to retrieve the data till the current date of the month.

Half-year to date

The half-year to date functionality divides the year into two periods each of 6 months. The first half is from January till June and the second half is from July till December. The users can retrieve the data from the starting of the half they belong to till the month they currently are in. For example, the user is currently in March so Half-year to date will retrieve the data from Jan till March. If the user is currently in September so Half-year to date will retrieve the data from July till September.

Quater to date

The quarter to date functionality divides the year into four periods each of 3 months. The first quarter is January till March, the second quarter is April till June, the third quarter is July till September, the fourth quarter is October till December. The users can retrieve the data from the starting of the quarter they belong to till the month they are currently in. For example, the user is currently in August so Quarter to date will retrieve the data from July till August.

Balances

Balances help the user to retrieve the data in the way they are currently saved on the system level. The data retrieved will be the same as the user has saved the only difference is in the sign. The Income and Liabilities are stored as negative numbers whereas the Expense and Assets are stored as positive numbers.

PreviousHow-To (Book Context)NextAdvanced

Last updated 2 years ago