topic Re: trying to use the Aggregated measure Relative Period in SAS Visual Analytics

trying to use the Aggregated measure Relative Period

mhamlett — Tue, 26 Jul 2016 14:49:25 GMT

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

mhamlett — Wed, 27 Jul 2016 18:50:55 GMT

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.

mhamlett — Mon, 01 Aug 2016 12:38:57 GMT

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.