Browse by Tags
Community Home » All Tags » lastperiods( RSS)
-
Let's say I have daily time series data that I then create a hierarchy for as year, month, day. If I want to look at yesterday's value, it seems east enough: ((Value]) OVER (PreviousPeriod([Axis.X])) However, what if I want to plot something lagged by 5 days or 10 days---not the value over the...
Posted to
Forum
by
hgl
on
Tue, Jul 5 2011
-
What's Wrong with this case when dayofmonth([Date])=3 then avg([ET Net Production]) OVER (LastPeriods(3,[Date])) else 0 end instead of going back to 3 rows and do the calculation, but it jumps to 3rd of every month by mean from the 3rd of the month it should ccalculate the 1st, 2nd and 3rd, but instead...
-
Hi All, Please I need to create a calculated Column which will calculate the moving average for a month. If I use LastPeriods function I need to know in advance how many days it should go back like for last five days I have to write in Avg([Production]) Over (LastPeriods(5, [Date])), which really don...
-
I would like to create the column 5- day average below. When I use "over last periods" statement it gives me a moving average. Does anyone know how to get the result below? I think I need to make a hierarchy out of gas. However, I want the 5 day period to be = today - 5. Gas Production 5-day...
-
As per the documentation, the function lastperiods(x,[Axis.X]) should return the current node and the x - 1 previous nodes. However, it returns the current node and the x previous nodes. ----------------------------------------RESOLUTION---------------------------------------- This issue has been fixed...
Page 1 of 1 (5 items)
|
|
|