topic Re: Simple Excel chart not able to develop in SAS Visual Analytics in SAS Visual Analytics

Simple Excel chart not able to develop in SAS Visual Analytics

soumyasen — Tue, 16 Feb 2016 12:34:53 GMT

Hi Everybody

I am trying to create a simple Excel Bar chart in SAS Visual Analytics. I have to make year on year comparison for the values of different kinds of measures in a bar graph.

I have attached the excel graph with the data.

It may be very simple but its urgent.

Kind Regards

Soumya Sen

Re: Simple Excel chart not able to develop in SAS Visual Analytics

Sam_SAS — Tue, 16 Feb 2016 14:59:51 GMT

For convenience, here is the graph from Soumya's spreadsheet:

The bar chart has 3 measures, a group variable, but no category variable.

Anyone have a suggestion of how this can be created in VA?

Thanks,

Sam

Re: Simple Excel chart not able to develop in SAS Visual Analytics

PeterWijers — Tue, 16 Feb 2016 16:09:17 GMT

Hi Soumya,

Its possible while making a new calculated field per year. I did cut off the left axis...

Use the following code per year (F.Year in our case)

IF ( 'F.Year.'n = Year(DatePart(Now())) )
RETURN 'Sal.Val.€.'n
ELSE 0

And this one for the last year.

IF ( 'F.Year.'n = ( Year(DatePart(Now())) - 1 ) )
RETURN 'Sal.Val.€.'n
ELSE 0

Drag both variables into the bargraph and magic happens....

Greetings Peter

Re: Simple Excel chart not able to develop in SAS Visual Analytics

soumyasen — Wed, 17 Feb 2016 07:45:20 GMT

I have developed the following variables:

My variable is named ‘Year’ so used Year('Year'n): so dint get confused on that.

For measure variable loss and for 2015 I have created a new variable called FY2015_loss

IF ( Year('Year'n) = ( Year(DatePart(Now())) - 1 ) )

RETURN 'loss'n

ELSE 0

For measure variable loss and for 2016 I have created a new variable called FY2015_loss

IF ( Year('Year'n) = Year(DatePart(Now())) )

RETURN 'loss'n

ELSE 0

For measure variable revenue and for 2015 I have created a new variable called FY2015_revenue

IF ( Year('Year'n) = Year(DatePart(Now())) )

RETURN 'loss'n

ELSE 0

For measure variable revenue and for 2016 I have created a new variable called FY2016_revenue

IF ( Year('Year'n) = Year(DatePart(Now())) )

RETURN 'loss'n

ELSE 0

But when I am assigning the variables the visual is not getting generated.

Please find attached in the last page what is the error.

Re: Simple Excel chart not able to develop in SAS Visual Analytics

soumyasen — Wed, 17 Feb 2016 07:47:36 GMT

Also one thing how did you cut the left axis

Re: Simple Excel chart not able to develop in SAS Visual Analytics

PeterWijers — Fri, 19 Feb 2016 05:54:50 GMT

You have not used a category yet, and you must use it to have the bars to show.
Thats what i see in your screen print, the rest seems to be ok.
Greetings

Re: Simple Excel chart not able to develop in SAS Visual Analytics

PeterWijers — Wed, 17 Feb 2016 19:20:34 GMT

The axes have been cut off for this screenprint.
Not that VA could do this .
Greetings

Re: Simple Excel chart not able to develop in SAS Visual Analytics

soumyasen — Fri, 19 Feb 2016 11:28:12 GMT

Thanks but in the excel we are not using any category .

Re: Simple Excel chart not able to develop in SAS Visual Analytics

PeterWijers — Fri, 19 Feb 2016 11:32:21 GMT

I am very confused now.

Your categories are Expence, Debt and CostOfDebt.....

Greetings

Re: Simple Excel chart not able to develop in SAS Visual Analytics

soumyasen — Fri, 19 Feb 2016 12:57:24 GMT

But Thanks a lot.

Using a category I can arrive at that.

Re: Simple Excel chart not able to develop in SAS Visual Analytics

soumyasen — Fri, 19 Feb 2016 12:59:18 GMT

One thing . My Measure values are under Expense, Debt . They are not categories /neither they appear under category list in SAS VA

Re: Simple Excel chart not able to develop in SAS Visual Analytics

soumyasen — Fri, 19 Feb 2016 13:01:39 GMT

Sorry to confuse you.

In my excel sheet you will find Year as my category.

And Expense ,Debt and Cost of Debt as the measure variables. So they dont appear under the category list.

Kind Regards

Soumya Sen