Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

trying to use the Aggregated measure Relative Period

Accepted Solution Solved
Reply
Contributor
Posts: 59
Accepted Solution

trying to use the Aggregated measure Relative Period

what i am doing seems simple enough but not able to get a value displayed.

 

i have a table with sales, salesdate(this is a normal date field with month day and year)

their is one record for each day.

 

i want to show in a table objecty , current day and previous day sales and of course Diff and % Diff.

the relative period calculation seems that it would allow me to create a new measure for yesterdays sales.

 

simply....

RelativePeriod(_Sum_, 'sales'n, 'salesdate'n, _Inferred_, -1, _Full_, {Date})

 

cannot get any value to display.

thanks for your help


Accepted Solutions
Solution
‎08-01-2016 08:39 AM
Contributor
Posts: 59

Re: trying to use the Aggregated measure Relative Period

i submitted a bug request.

sas does not call this  a bug even tho the documentation states it works.

they call it a feature request.

sas support has put my name in as a requestor of the feature.

 

problem not resolved but in the queue.

View solution in original post


All Replies
Contributor
Posts: 59

Re: trying to use the Aggregated measure Relative Period

[ Edited ]

from everything i read and have seen, this should work, but doesnt.

noone seems to be able to resolve the issue or maybe noone needs yesterdays measures.

the documentation states quite plainly what this feature does, how to code it and what it displays.

 

i will report as a bug to sas support.

 

Solution
‎08-01-2016 08:39 AM
Contributor
Posts: 59

Re: trying to use the Aggregated measure Relative Period

i submitted a bug request.

sas does not call this  a bug even tho the documentation states it works.

they call it a feature request.

sas support has put my name in as a requestor of the feature.

 

problem not resolved but in the queue.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 281 views
  • 0 likes
  • 1 in conversation