cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
angeldbracho
‎04-26-2019
  • 4 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Aggregate variables with multiple conditions

by Calcite | Level 5 in SAS Visual Analytics
‎03-19-2019 10:24 AM
‎03-19-2019 10:24 AM
Hey guys, hope you're going well.    I'm having some trouble and I hope you would help.  I have this data:    Moth Code  Money   Plan  Business Unit 1/1/2019 52007 -              0,50 -            569,79 A 1/1/2019 52007 -              0,04 -            569,79 A 1/1/2019 52007 -              0,22 -            569,79 A 1/1/2019 52007                1,53 -            569,79 A 1/1/2019 52007 -              1,23 -            569,79 A 1/1/2019 52011 -0,71 -971,3121737 A 1/1/2019 52011 -0,22052 -971,3121737 A 1/1/2019 52011 10,25 -971,3121737 A 1/1/2019 52011 2,32 -971,3121737 A 1/1/2019 52011 -0,95887 -971,3121737 A 1/1/2019 52011 -0,05 -8617,361473 B 1/1/2019 52011 -0,00014 -8617,361473 B 1/1/2019 52011 0,01 -8617,361473 B 1/1/2019 52011 -0,01 -8617,361473 B 1/1/2019 52011 -0,02 -8617,361473 B 1/1/2019 52011 -0,01 -8617,361473 B 1/1/2019 52011 -0,01 -8617,361473 B 1/1/2019 52011 -0,01 -8617,361473 B 1/1/2019 52011 -0,01 -8617,361473 B 1/1/2019 52011 -0,01 -8617,361473 B 1/1/2019 52011 -0,01 -8617,361473 B 1/1/2019 52016 -0,00071 -7,278911158 B 1/1/2019 52016 -0,00004 -7,278911158 B   As you can see, the value column "PLAN" is the same for each month&code&BusinessUnit. I want to create a crosstab in SAS Visual analytics (7.3) that shows "plan" but I don't know how to not-repeat each plan value or sum it. I mean, if I filter a Code, I would like to see this in SAS:    Month Code  Money   Plan  Business Unit 1/1/2019 52007 -              0,46 -            569,79 A   This is, I want SAS to effectively SUM the "money" column, but not sum the "plan" column, just put the value (that repeats in EACH line in the original data).   I've been trying and reading lots of things but still can't get it. Anyone knows? Can you help me please?   Thank you in advance!! ... View more

Re: Time slider with dynamic range for last 2 months

by Calcite | Level 5 in SAS Visual Analytics
‎02-14-2019 08:12 AM
‎02-14-2019 08:12 AM
Hi guys, hope you are well. I'm having a little trouble with SAS VA 7.4, I'd be glad if you could help me.   I have data from two years: 2017 and 2018 (I'm interested in a numerical variable). I put a slider (period) that's filtered, to show only 2018 values.       I want to make a bar chart, that shows, for a category, the cumulative amount for the selected period in the slider (no problem with that) but also the cumulative amount for the same month in the previous year.   The blue bars are ok but not the Green ones (cumulative period of the same month, previous year). I'm trying with the aggregated measure "cumulative period" set for previous year (-1) but it doesn't work, and don't know why, although it worked well when using it in a cross table with "period" as columns.     Can you help me?   Thanks and regards!! ... View more

Cross Tab with multiple customized categories and with hierarchies - S...

by Calcite | Level 5 in SAS Visual Analytics
‎01-18-2019 10:10 AM
‎01-18-2019 10:10 AM
Hi people   I'm using SAS VisualAnalytics 7.4   I was trying to create a cross table with the same idea you wrote, I mean, creating customized categories. But unfortunately I have been having a problem since I can not use more than one categorie as files in order to organize the visualization like a vertical list.    What I would like to create is a cross tab where I have a vertical list of several customized categories and a hierarchy inside of every category.   Do you know any way to get this visualization?   I really would appreciate any help you could give me.   Regards!   PD: It should be like the image attached ... View more

Re: Crosstab Object - How can I create groupings of Measure Columns in...

by Calcite | Level 5 in SAS Visual Analytics
‎01-18-2019 10:10 AM
‎01-18-2019 10:10 AM
Hi Basl,    I'm using SAS VisualAnalytics 7.4   I was trying to create a cross table with the same idea you wrote, I mean, creating customized categories. But unfortunately I have been having a problem since I can not use more than one categorie as files in order to organize the visualization like a vertical list.    What I would like to create is a cross tab where I have a vertical list of several customized categories and a hierarchy inside of every category.   Do you know any way to get this visualization?   I really would appreciate any hel you could give me.   Regards!   PD: It should be like the image attached ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎04-26-2019 02:03 PM
Quick links