topic Aggregated measure to measure in SAS Visual Analytics

Aggregated measure to measure

ssnawaz — Thu, 15 Mar 2018 21:31:18 GMT

Hi,

How to convert an aggregate measure to measure value.

Thanks,

Nawaz.

Re: Aggregated measure to measure

ballardw — Thu, 15 Mar 2018 22:29:14 GMT

You really need to provide some detail about what you have and what you are attempting. What kind of "aggregate" do you currently have? What kind of disaggregate to think you want from that?

One example of a somewhat better description: I have a numeric value that is the total sum of sales for a calendar month and I want a daily value if sales were made on 24 days.

From that a daily value of the average sale could be made such as total/24.

But I have a numeric value of 1234 and want to get something else requires some additional information.

Hint: if all you have is a percent or sum there could be many ways to get back to some "measure" but utility of some if not most may be questionable.

Re: Aggregated measure to measure

ssnawaz — Thu, 15 Mar 2018 23:02:25 GMT

I have a custom graph made of both Scatter plot and Line graph(Line graph runs in both x axis and y axis).

The Problem or solution i require is for the line graph.

In the line graph (for now lets only consider x axis):

Line graph needs to show the average.

The variables needed is already calculated using aggregate measure [i.e., (Group by)P values / (group by All)Q values = XX]

So XX is the aggregated measure.

Now i want to calculate a simple average(ex: 20/10 = 2, So the average should be 2) which i can use in the line graph(created in custom graph).

Now when i use the - Avg(XX) in aggregated measure, i cant do that as SAS VA says i cant use an aggregated function).

So i am looking for solution for this.

Thanks.