topic Re: MoM growth of the current month in text object in SAS Visual Analytics

MoM growth of the current month in text object

jmehul — Mon, 09 Jul 2018 14:04:40 GMT

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

Re: MoM growth of the current month in text object

MikeJenista — Mon, 09 Jul 2018 17:03:13 GMT

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.

Re: MoM growth of the current month in text object

jmehul — Mon, 09 Jul 2018 17:04:58 GMT

I am using SAS VA 9.4

Re: MoM growth of the current month in text object

MikeJenista — Mon, 09 Jul 2018 17:23:41 GMT

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.

Re: MoM growth of the current month in text object

jmehul — Fri, 13 Jul 2018 08:47:02 GMT

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