topic Re: Cumulative Period does not work in SAS Visual Analytics

Cumulative Period does not work

Mkomen — Wed, 27 Mar 2024 10:18:35 GMT

I am having some troubles with the Cumulative periode measure as it refuses to show any data. No matter how I change the settings; different aggregation, different date, different measures, different settings in de cumulativeperiode (inferred, month, applytimeframefilter) no results.

Can anyone spot what I am doing wrong?

Re: Cumulative Period does not work

Sam_SAS — Wed, 27 Mar 2024 14:20:55 GMT

Hello,

Looking at the images you provided, the calculation should work.

Is it possible that you have two data items in your data source that are named "Datum"? If the date column is not the same (in the calculation and in the list table object), then the calculation will return missing values.

Sam

Re: Cumulative Period does not work

acordes — Wed, 17 Apr 2024 14:07:02 GMT

It is very restrictive, but it works.

Only the first block design works and returns the desired aggregation for a cumulative peridod.

It fails, if there are 2 different dates in the object (block at the right does not accumulate meanwhile the left one does although the unique difference resides in the added date1 column.

It derails as well when you 'duplicate' the timeseries, in the middle it occurs because you duplicate a date by choosing detail data for the list object.

But you can 'break' the timeseries and it still works and aggregates correctly. This would be the case you have no sales for one month.

And it executes properly if you have a timeseries like '01jan2023' '01feb2023' '28mar2023' '01apr2023'.

Re: Cumulative Period does not work

Mkomen — Thu, 25 Apr 2024 13:33:42 GMT

Thanks! I managed to get it to work now.

Excuse for the delayed reply...i was on holiday!