topic Re: I Need Average Value in SAS VA in SAS Visual Analytics

I Need Average Value in SAS VA

PavanKumar2 — Wed, 05 Dec 2018 04:56:51 GMT

I have 4 columns as Portfolio, ReleaseID, BudID ,Difference in days In List table.

example:

Sales ,17.4, 132,13

sales ,17.4, 133.12

sales ,17.4, 134,12

average : (13+12+12)/3 --12.33

I need : Portfolio ,ReleaseID ,Average in days(Here I want summary based on Portfolio and ReleaseId) in List table.

Sales ,17.4, 12.33

Average formulae Is in aggregated Measure here it is taking group by

avg (group by) (Measure)

when I am doing this Avg (Groupby) (Difference in days) here I am getting Problem.(13/1+(12+12)/2)

if difference in days are same then I am getting problem.

It will take group by on Difference in days but I need group by (13+12+12)/3. But in aggregated Measure if we use average Formulae by default it asks for group by value.

Is there any way to calculate Avg

Re: I Need Average Value in SAS VA

Sam_SAS — Wed, 05 Dec 2018 15:25:41 GMT

Hello Pavan,

Are you sure you want an aggregated measure here? If you just change the aggregation of the measure to Average, then that will evaluate the average values for your totals row in the list table.

That is to say, I don't think it should be necessary to create a new data item in this case.

Does that help?

Thanks,

Sam

Re: I Need Average Value in SAS VA

PavanKumar2 — Mon, 10 Dec 2018 09:22:46 GMT

Hi sam ,

Thanks for your advise . I have duplicate values in Measure to avoid that I have divided that measure with frequency and got Difference in days as Aggregated Measure (Frequency can only be used in Aggregated Measure).Here I need to get average number of days for that aggregated measure.

Is there any other alternative to find solution

I am attaching a screen shot FYI.

Re: I Need Average Value in SAS VA

Sam_SAS — Tue, 11 Dec 2018 14:45:33 GMT

Hello Pavan,

What expression are you using to get the screenshot you posted?

Do you want to determine the average value for "Difference in days for DTAT with frequency"?

Thanks,

Sam

Re: I Need Average Value in SAS VA

PavanKumar2 — Wed, 12 Dec 2018 06:07:39 GMT

Hi sam ,

Yes. I want average value for "Difference in days for DTAT with frequency .

Re: I Need Average Value in SAS VA

Sam_SAS — Wed, 12 Dec 2018 13:59:21 GMT

Can you share the aggregated expression you are using to calculate "Difference in days for DTAT with frequency"?

I am still not sure I understand why you do not simply assign the Average aggregation to the "Difference in Days" measure.