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

MoM growth of the current month in text object

Accepted Solution Solved
Reply
Contributor
Posts: 25
Accepted Solution

MoM growth of the current month in text object

Hi All,

 

I want to make a text object (KPI) to show the latest month on month growth %.

 

I am using the Aggregate measure as follows:

 

( Period(_Sum_, 'sale'n, _ApplyAllFilters_, 'date'n, _ByYear_) - ParallelPeriod(_Sum_, 'sale'n, _ApplyAllFilters_, 'date'n, _ByYear_, _ByYear_, -1, _Full_, {Date}) )

/ ParallelPeriod(_Sum_, 'sale'n, _ApplyAllFilters_, 'date'n, _ByYear_, _ByYear_, -1, _Full_, {Date})

 

And then setting up the rank in the rank tab as month = max_month (top count =2)

 

I am able to see it in list table but when I put it on the text object, it is showing missing value which is obvious. 
As sum(missing , any value) = missing.

Is there any way in which I can do this thing.

 

 Thanks 


Accepted Solutions
Solution
‎07-09-2018 01:48 PM
SAS Employee
Posts: 31

Re: MoM growth of the current month in text object

Okay, the simplest way I know to get the growth number to show is to assign the aggregated item to a chart where it would show as a single element.  For example, if you use the same rank you describe on a pie chart, you would get the aggregated value for only one slice (showing as the whole wheel).  You could then use the style and properties tabs to make the numeric value show very large and provide a title.

View solution in original post


All Replies
SAS Employee
Posts: 31

Re: MoM growth of the current month in text object

What version of VA are you on?  The latest versions have a KPI object that does exactly what you want, but for earlier versions there are still some possibilities.

Contributor
Posts: 25

Re: MoM growth of the current month in text object

Posted in reply to MikeJenista

I am using SAS VA 9.4

Solution
‎07-09-2018 01:48 PM
SAS Employee
Posts: 31

Re: MoM growth of the current month in text object

Okay, the simplest way I know to get the growth number to show is to assign the aggregated item to a chart where it would show as a single element.  For example, if you use the same rank you describe on a pie chart, you would get the aggregated value for only one slice (showing as the whole wheel).  You could then use the style and properties tabs to make the numeric value show very large and provide a title.

Contributor
Posts: 25

Re: MoM growth of the current month in text object

Posted in reply to MikeJenista

Is there any other method or formula for calculating YoY, QoQ or MoM so that I can get rid of that missing value.

If not in SAS 9.4

 

Is there any other way on SAS VIYA 

☑ This topic is solved.

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

Discussion stats
  • 4 replies
  • 114 views
  • 0 likes
  • 2 in conversation