I have a chart which shows a years worth of figure on a daily basis. There are downward spikes on this at the weekends. Is there a way in which this can be removed somehow, possibly by a rolling/moving average or by another method?
Any help or insight into this would be much appreciated.
Well in your case you probably want to exclude the weekends, because those are not representative for the analysis, right ?
What I'd try is using a claculated dimension that would return null() (and suppress it) for all the weekends:
if(Weekday(myDate)>=5, null(), myDate)
Then you just check "suppress value when null()"
If you didn't want to exclude weekends, then you can build the Moving Average formula, using a combination of functions RangeAvg() and Above(), but those make the chart look funny sometimes...
