topic Re: Percent difference from previous period in SAS Visual Analytics

Percent difference from previous period

dstephens22 — Fri, 23 Jul 2021 13:21:19 GMT

Can someone explain why this results in all nulls? It's a "Percent difference from previous period" but I am not using _month_, I and using _inferred_. It's a week over week calculation. I can seem to find an answer.

Thanks, Dave

This is the code produced by SAS VA.

( RelativePeriod(_Sum_, 'Pageviews'n, _IgnoreAllTimeFrameFilters_
, 'EndDate'n, _Inferred_, 0, _Full_, {Date}) - RelativePeriod(
_Sum_, 'Pageviews'n, _IgnoreAllTimeFrameFilters_, 'EndDate'n,
_Inferred_, -1, _Full_, {Date}) ) / Abs(RelativePeriod(_Sum_,
'Pageviews'n, _IgnoreAllTimeFrameFilters_, 'EndDate'n, _Inferred_
, -1, _Full_, {Date}))

Re: Percent difference from previous period

dstephens22 — Fri, 23 Jul 2021 13:22:06 GMT

BTW if i use _month_ it's fine. Does SAS VA not like days?

Re: Percent difference from previous period

Sam_SAS — Fri, 23 Jul 2021 13:33:23 GMT

Hi Dave,

Day and Week intervals were not supported until the 8.3 release. Do you have a version of VA that is older than that?

Sam

Re: Percent difference from previous period

dstephens22 — Fri, 23 Jul 2021 13:38:30 GMT

Yes it's 7.5. I swore I used this in previous versions. Maybe before Flash was removed.

Thanks for the info. I'll hardcode on backend I guess.