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

Our Support systems migrated on Saturday, May 21. We'll automatically forward you to the new location for this content.

Data360 Analyze: Log4j Vulnerabilities (CVE-2021-44228, CVE-2021-45046, CVE-2021-4104, CVE-2021-45105 and CVE-2021-44832)
Data360 Analyze: important note before upgrading to 3.8.0
Data360 Analyze Migrations Package
Data360 Analyze Welcome Pack
Precautions to take before upgrading to Data360 Analyze 3.6.0 Server
Access to the 'function:login' is denied. Required:xPossessing:
When exporting dataflows from one Environment to Another Environment passwords are not exported properly
Error Code: org.infinispan.commons.cacheException
WebApplicationContext for namespace "main-servlet"
Data360 Analyze - How to check if a field exists and add it if it doesn't

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