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

Parallel period percent function not working as expected

Reply
Occasional Contributor
Posts: 11

Parallel period percent function not working as expected

Hi Experts, 

 

I have created a a column "% growth from previous year: using Parallel period percent using "Transaction date" function

 

Usibg the attached function.

 

Alothough I have values on Transaction date for different months but I can on see % value only for January.  

 

Kindly suggests.

 

Regards

Arpan

Attachment
Occasional Contributor
Posts: 18

Re: Parallel period percent function not working as expected

Hi Arpan,

 

What happens if you try to change your outer boundaries (_Inferred_) in the function to _Year_?

 

How is your Rev. in INR (Cr.) built up in the data-set?

 

/Regards

Occasional Contributor
Posts: 11

Re: Parallel period percent function not working as expected

Hi Daha,

 

Even we change outer boundaries (_Inferred_) in the function to _Year_  it gives me the same output.

 

Rev. in INR (Cr.) is buid up in SAS VA as attached.

 

Regards

Arpan

Attachment
SAS Super FREQ
Posts: 274

Re: Parallel period percent function not working as expected

Hello Arpan,

 

Could you try a simple bar chart of your %Growth aggregated measure versus Transaction Date?

 

The periodic operators require that the same date/time variable that you specified for the operator be assigned to the report object.

 

Thanks,

Sam

Occasional Contributor
Posts: 11

Re: Parallel period percent function not working as expected

Hi Sam, 

 

We dont see any data value when we plot a bar chart  %Growth aggregated measure versus Transaction Date.  As we need  %Growth aggregated measure rolled up for each month.

 

It weired that %Growth vs last year formula is working only for month of January. We have put data source filter to include data for FY15 and FY16.  So ideally it should work but unfortunately not working for other months except January.

 

PFA screen shots

 

Regards

Arpan

Attachment
SAS Super FREQ
Posts: 274

Re: Parallel period percent function not working as expected

Hello Arpan,

 

The periodic operators return missing values when the inferred inner interval is by Day. I believe this is why your bar chart of Transaction Date is empty.

 

In your aggregated expression, can you set the inner interval to be _ByMonth_ instead of _Inferred_?

 

I'm not sure why January is receiving a value when you plot versus Month  -- in theory all values should be missing because the Transaction Date variable is not assigned.

 

Can you let us know if setting the inner interval makes a difference?

 

Thanks,

Sam

Occasional Contributor
Posts: 11

Re: Parallel period percent function not working as expected

Hi Sam, 

 

Even after changing the inner interval to be _ByMonth_ , still the issue persists.

 

Regards
Arpan

SAS Super FREQ
Posts: 274

Re: Parallel period percent function not working as expected

[ Edited ]

Hello Arpan, 

 

Sorry this has continued to be an issue.

 

On my 7.3 install I am able to get a good result with a very similar aggregated expression:

period.png

 

When I plot this versus Date, I get this:

 

period2.png

 

There are bars for each day because the format of the date variable. Because of the number of category values, you have to zoom in a bit for the bars to be drawn.

 

If you make your aggregated item based on a date variable with a month format, you could get a result like this:

period4.png

 

It should be noted that because of the way the periodic operator works, the first period (year) of data will be missing because there is no previous period to compare to. So if your data is filtered to include only 2014 and 2015, then the values for 2014 will be missing because the 2013 values are not available to calculate the 2014 growth.

 

I'm not sure why you are not seeing ANY results for your aggregated item when Transaction Date is assigned to the chart and when the inner interval is set to _byMonth_.  You might want to contact SAS Technical Support if you are still stuck.

 

Thanks,

Sam

Post a Question
Discussion Stats
  • 7 replies
  • 600 views
  • 0 likes
  • 3 in conversation