We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.

Data360 Analyze Migrations Package
Data360 Analyze Welcome Pack
Precautions to take before upgrading to Data360 Analyze 3.6.0 Server
Data360 Analyze: rounding / accuracy issues
Data360 Analyze: how to loop through columns & set nulls to alternative values
Data360 Analyze: how to capture node logs
Data360 Analyze: how to aggregate based on time
Data360 Analyze: temp file for a dataflow grows significantly
Data360 Analyze: how to add a date as a property type
Data360Analyze: how to set JAVA_HOME on Windows

Data360 Analyze: how to aggregate based on time

Christina Costello

July 07, 2021 13:47
Updated

USE CASE:

I want to aggregate data in Analyze using a time column to be dependent on it.
I want to aggregate data from all 12 months for each line prior to that data, and so on for the other date periods, i.e. would be a rolling total of all12 previous lines.

Please see the dataflow & sample data attached as an example of how this can be achieved.

Support - Waterfall Values - 7 Jul 2021 (1).lna
9 KB Download
Example.xlsx
9 KB Download

Comments

0 comments

Please sign in to leave a comment.

Articles in this section

Related articles