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
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
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
I have developed the following variables:
My variable is named ‘Year’ so used Year('Year'n): so dint get confused on that.
IF ( Year('Year'n) = ( Year(DatePart(Now())) - 1 ) )
RETURN 'loss'n
ELSE 0
IF ( Year('Year'n) = Year(DatePart(Now())) )
RETURN 'loss'n
ELSE 0
IF ( Year('Year'n) = Year(DatePart(Now())) )
RETURN 'loss'n
ELSE 0
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.
Also one thing how did you cut the left axis
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
Thanks but in the excel we are not using any category .
I am very confused now.
Your categories are Expence, Debt and CostOfDebt.....
Greetings
But Thanks a lot.
Using a category I can arrive at that.
One thing . My Measure values are under Expense, Debt . They are not categories /neither they appear under category list in SAS VA
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
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.