Hub
Pricing About
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Community Hub
  • knime
  • Spaces
  • Examples
  • 00_Components
  • Financial Analysis
  • Calculate Recurring Values
ComponentComponent

Calculate Recurring Values

KNIME profile image

Last edited: 

Drag & drop
Like
Use or download
Copy short link
This component formats data before analyzing recurring events, such as monthly or annually recurring revenue. In the input table, each record holds a time period, an ID, and some numeric value. These records could be, for example, contracts with different customers. In the formatted output table, each record holds a time point within the time period, ID, and value. This value is calculated by dividing the original value by the number of single time points within the time period. The granularity of the single time points can be set to "Days" or "Months". Required extensions: - KNIME Math Expression (JEP) (https://hub.knime.com/knime/extensions/org.knime.features.ext.jep/latest) - KNIME Quick Forms (https://hub.knime.com/knime/extensions/org.knime.features.js.quickforms/latest)

Component details

Input ports
  1. Type: Table
    Contracts data
    - Two columns of type Date&Time that define the start and end date of the time period - Numeric or string column for the IDs that identify each record - Numeric column for the values that are assigned to each time period and ID
Output ports
  1. Type: Table
    Recurring values
    - Column of type Date&Time for the single time points that have been extracted from each time period - String or numeric column for the IDs of the records - Numeric column for the values assigned to each time point and ID

Used extensions & nodes

Created with KNIME Analytics Platform version 4.2.0
  • Go to item
    KNIME Base nodes Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.2.0

    KNIME profile image
    knime
  • Go to item
    KNIME Javasnippet Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.2.0

    KNIME profile image
    knime
  • Go to item
    KNIME Math Expression (JEP) Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.2.0

    KNIME profile image
    knime
  • Go to item
    KNIME Quick Forms Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.2.0

    KNIME profile image
    knime
  • Go to item
    KNIME Statistics Nodes Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.2.0

    KNIME profile image
    knime
  1. Go to item
  2. Go to item
  3. Go to item
  4. Go to item
  5. Go to item
  6. Go to item

Legal

By using or downloading the component, you agree to our terms and conditions.

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • E-Learning course
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • KNIME Open Source Story
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more on KNIME Business Hub
© 2023 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits