Calculating or filtering an aggregated calculation in SAS Visual Analytics Version 7.3

[AK100]

Hello All,

I have made an aggregated calculation is SAS Visual Analytics which gives me the Average of all the values from all the Types which I select in a list. He does this based on all the values from 1 month. Right now I want to tell this aggregated calculation to give me the average just based on the highest values for each day and for each type. That type will still be selected by me using a list. It sounds simple but its not because the calculation must be dynamic based on the type I select and just selecting the highest values for each type and each day. Based on that selection he gives me back the avg value of the month.

So actually I need an aggregation of an aggregated calculation or maybe filter an aggregated calculation, both options did not work out for me.

Hope someone can give me a quick solution, Thank you indeed. 

*Please note that I use SAS VA version 7.3

[FredrikE]

Hi!

Actually I think it is not possible in 7.3, might be in 7.4 and almost sure it works in 8.5...:)

//Fredrik

[AK100]

Thank you for your honest answer.