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

Relative period function : weird behaviour ?

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 18
Accepted Solution

Relative period function : weird behaviour ?

Dear all,

To be able to use the "relative period" function, you will agree that I need the data of the previous period right ? in addition to the current one ?
Which means for example a montly value for 2017 and 2018 :
Date - Quantity
1/2017 43
2/2017 67
3/2017 67
...
1/2018 67
2/2018 54
etc...

 

The point is, when I create a relative period function, I don't want the 2017 data to be displayed in my graph or table, only the 2018 with NEXT to it, the relative n-1 field. But this is what I get :

2018-07-10_11-58-26.png

So I filter my table or graph to show up only 2018 data, and then the relative period function does not work anymore :

2018-07-10_11-58-53.png
Really strange...
Did I miss something?
I'm using VA 7.4.

thanks


Accepted Solutions
Solution
‎07-12-2018 09:09 AM
Occasional Contributor
Posts: 18

Re: Relative period function : weird behaviour ?

Thanks to @TeriPatsilaras_sas who kindly replied to her blog with the solution.

I had to change a value in the Aggregated Measures to IGNORE time filtering.

 

https://blogs.sas.com/content/sgf/2018/04/19/sas-visual-analytics-filters-on-periodic-calculations-a...

 

Have good holidays everyone.

View solution in original post


All Replies
Occasional Contributor
Posts: 18

Re: Relative period function : weird behaviour ?

sounds like everyone has left on holidays? Smiley Tongue

Solution
‎07-12-2018 09:09 AM
Occasional Contributor
Posts: 18

Re: Relative period function : weird behaviour ?

Thanks to @TeriPatsilaras_sas who kindly replied to her blog with the solution.

I had to change a value in the Aggregated Measures to IGNORE time filtering.

 

https://blogs.sas.com/content/sgf/2018/04/19/sas-visual-analytics-filters-on-periodic-calculations-a...

 

Have good holidays everyone.

☑ This topic is solved.

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

Discussion stats
  • 2 replies
  • 135 views
  • 2 likes
  • 1 in conversation