Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Using Aggr(...), expressions, and max

Hello, I am trying to use Aggr(....) and I'm having problems. This is how I understand it works.

Max(
  { < Date = {"=Aggr(Date, @5)"} > }
   @5
)

This code will make a table out of Date and @5 and find the max value of @5. The thing is, I need @5 to be an expression. How can I extract the max of the second column in my table created by Aggr? It doesn't seem to work with just the expression in the place of all the @5's, should that work?

3 Replies
Jason_Michaelides
Luminary Alumni
Luminary Alumni

Erm...I don't inderstand!  What do you want your finished chart to show, exactly?  Please give an example expression.

Not applicable
Author

It's just for a variable. So I just need the one value.

Jason_Michaelides
Luminary Alumni
Luminary Alumni

Help me out here...please provide some specific examples and if possible some sample data.  Makes helping you a lot easier...