topic Re: Calculate a cumulative sum over the the largest peariod available in the data in SAS Visual Analytics

Calculate a cumulative sum over the the largest peariod available in the data

AsmaFejjari — Fri, 28 Oct 2016 16:58:14 GMT

Hi,

I am new with VA

I would like to represent an increasing curve over time that represent cumulative values for years ( 10 years )..

To build my variable I used :

CumulativePeriod(_Sum_, "Mesure", Date , _Inferred_, _ByYear_, 0, _Full_, )

but The cumulativeperiod function calculates only over one year.

PS: the depth of the historical data available is not fixed,it depends on an other categorie variable..

Thanks in advance

Re: Calculate a cumulative sum over the the largest peariod available in the data

Pete_J_L — Fri, 24 Mar 2017 01:24:36 GMT

Hi Asma

I'm new to VA too. This is the first thing I tried to do. And then I find it can't even perform a basic cumulative function over more than a year.

The mind boggles.

Re: Calculate a cumulative sum over the the largest peariod available in the data

itchyeyeballs — Sat, 25 Mar 2017 09:54:55 GMT

Have a look at my post in this thread should give you what you need,

you basically have to calculate each year separately then add together

Re: Calculate a cumulative sum over the the largest peariod available in the data

Pete_J_L — Sat, 25 Mar 2017 21:53:52 GMT

Thank you! I'll give that a try. Just to clarify for my newbie brain, how does one create aggregate measures of prior years?

Re: Calculate a cumulative sum over the the largest peariod available in the data

itchyeyeballs — Sat, 25 Mar 2017 22:00:18 GMT

Hi,

Theres guidance here on creating cumulative period data, you will just need to adjust item 6 in the first image shown in that link to pick how many years to go back, -1,-2 etc

Re: Calculate a cumulative sum over the the largest peariod available in the data

Pete_J_L — Sat, 25 Mar 2017 22:01:20 GMT

Thank you, much appreciated!

Re: Calculate a cumulative sum over the the largest peariod available in the data

itchyeyeballs — Sat, 25 Mar 2017 22:06:54 GMT

Let us know how you get on 🙂

Don't forget to mark the thread as solved if the suggestion works

Re: Calculate a cumulative sum over the the largest peariod available in the data

Pete_J_L — Sun, 02 Apr 2017 23:42:23 GMT

Thanks for the advice, I gave it a fair crack, but didn't have any luck. It's far too fiddly for what should be very basic functionality within VA.

Re: Calculate a cumulative sum over the the largest peariod available in the data

itchyeyeballs — Mon, 03 Apr 2017 00:22:54 GMT

Let us know where you hit problems,

I'm not one to pull my punches with VA (Think it lacks in several key areas) but in this case I'm not sure it would be any easier in competitor products as they all seem to work over one year periods and therefore need some fiddling

Re: Calculate a cumulative sum over the the largest peariod available in the data

Pete_J_L — Mon, 03 Apr 2017 00:38:34 GMT

In Tableau it is simple as creating a running total table calculation. There is no arbitrary time limit, and would would there be? It makes no sense.

I'm not having much luck creating the previous year aggregations in your solution, I'm also confused as to whether your solution uses the parallel period function or the cumulative period function, or some combination of both.

Re: Calculate a cumulative sum over the the largest peariod available in the data

itchyeyeballs — Mon, 03 Apr 2017 08:29:46 GMT

Hi,

I used the parallel period function for each preceding year and added them together.