Hi everyone!   I'm kinda new to the SAS VA and I'm not being able to create a specific calculated field.   The idea is to calculate the average revenue/coupons we'll have to make on the rest of the year to complete our year goal.   My data is on the store level, so I'll have to aggregate it to make these as big numbers. I've attached a sample of the table I'm using.   The difficult part is to calculate the amount of months left in the year to use it as the denominator. Using the revenue as example, the formula I thought was something like:   Sum [_ForAll_] (( IF ( Month('anoMesData'n) <= ( Month(DatePart(Now())) - 1 ) ) RETURN 'revenueGoal2020' ELSE . )) - Sum [_ForAll_] (( IF ( Month('anoMesData'n) <= ( Month(DatePart(Now())) - 1 ) ) RETURN 'revenue2020' ELSE . ))/ 202012 - Month(DatePart(Now())) Is this the best way to make this calculation?   Thanks! ... View more

Hello!   I've created a Geomap that plots a bubble for each client according to their address, but I wanted to add a specific bubble (or a marker) to identify the store they had an order.   There are 2 different stores, and I've added a filter to select only one each time: Is there a feature on this type of object? The table I used for this dashboard already have the coordinates for the store.   Thanks! ... View more

Hello!   I have a data set that contains the Ids of my customers and their registration's date, besides the date each one made their first purchase (if they did it, meaning there are null values on this column):     I wanted to group them by the year and month of registration (Example: all customers registered on January/2019) and make a cumulative count of how many months it took for the first purchase, starting from their registration month until now. So if a customer that registered on January/2019 made his first purchase on February/2019, I want to count him from this month forward.   The objective is to compare if the recent customers are taking longer to start buying.   I imagine that the final data set would be somethin like this:     My final objective is to make a graphic comparing the % of each batch, similar to the example below:     Anyone knows how I could develop a data set in these conditions?   Sorry if my question is not clear enough, and I am available to give more details if necessary.   Thanks! ... View more

Hello!   I need to structure a base that compares the values day by day from last year (2019) with the equivalent days from this year (2020).   The problem is that these days must be equivalent not in a numerical form, but considering the weeks and weekdays.   For example: 01/05/2019 was the first Saturday from January, so in 2020 I need to compare it with 01/04/2019 (first Saturday from January in 2019).   Is there any function that calculates these dates automatically?   Thanks! ... View more