SAS Support Communities

Good morning everyone,   I have a dataset in SAS Enterprise Guide which I have attached to this post.   And the value that I want to see is E0, which has the following formula:   E0 = OPEX / Total Maintenance Costs * 100%   To calculate the E0 for the 1st Quarter of 2017, it would be like: E0(1st Quarter 2017) = SUM(OPEX(January,February,March) / SUM(Total Maintenance Costs(January,February,March) * 100%   And the same rational would be applied to the Monthly and Yearly calculation.   My problem is that people might want to see the value of E0 on Visual Analytics by those 3 different groups (Monthly, Yearly, Quarterly).   My first thought was to make all of the calculations on Enterprise Guide but that would lead me to an additional column (this would be awkward because of the number of rows) or table for each group.   My second thought was to make the calculations on Visual Analytics, since I can just create an aggregated measure and group by whatever is selected (Month, Quarter or Year).   Which is the best way? Which one, EG or VA, suffers more from the calculations? What is the best practice?   Is there a better solution than the ones that I presented?   Thank you very much! ... View more

Good afternoon,   I am using SAS VA 7.3, and so, I am using the horizontal gauge to display a single value which is "Total Production [MW]".   This single value is grouped (SUM) by the data that is either selected on the graphs or filtered on the control objects.    However, we have the category "Power Plant" defined as such:   Power Plant 1 - Generator 1 Power Plant 1 - Generator 2 Power Plant 1 (which is the total) Power Plant 2 - Generator 1 Power Plant 2 - Generator 2 Power Plant 2 - Generator 3 Power Plant 2 Power Plant 3 - Generator 1 Power Plant 3 - Generator 2 Power Plant 3 - Generator 3 Power Plant 3 - Generator 4 Power Plant 3 Total Power Plants   So basically, when I have selected of all of these categories to display on the bar graph (which the client requires) the total is not correct, because it group sums all of the categories, and I want to create and advanced filter on the gauge to basically say:   IF "Power Plant" NotContains "Generator" RETURN "Power Plant" NotContains "Generator" ELSE "Power Plant"   This means that if any category's selected are not Generators (which means they are totals) he would ignore the generators values and just SUM the totals. And if there are only Generators selected, he would SUM them up as normal.   I have created that code to no results, it doesn't filter anything.   Is there a way to solve this? Thank you all.  ... View more

Good morning,   We are having a problem where we have two different categories (months and years) and we are using lists embbebded into prompts for each category, like so: Months and Year filter However, when we have both years selected, he group sums the months and shows to total of January 2017 + January 2018 for every measure. Is there a way he doesn't automatically group sums the months?           ... View more