10-28-2016 12:58 PM
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
03-23-2017 09:24 PM
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.
03-25-2017 05:54 AM
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
03-25-2017 05:53 PM
03-25-2017 06:00 PM
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
04-02-2017 07:42 PM
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.
04-02-2017 08:22 PM
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
04-02-2017 08:37 PM - edited 04-02-2017 08:38 PM
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.