BookmarkSubscribeRSS Feed
dstephens22
Obsidian | Level 7

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}))

3 REPLIES 3
dstephens22
Obsidian | Level 7
BTW if i use _month_ it's fine. Does SAS VA not like days?
Sam_SAS
SAS Super FREQ
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
dstephens22
Obsidian | Level 7

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.

SAS INNOVATE 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 635 views
  • 4 likes
  • 2 in conversation