mini guage bounds

[#1]

Hello Experts ,

I have a issue regarding using expressions in mini guage charts ..,

I'm using mini guage in a straight box to display sum(Accounts) but in guage properties i want to give min & max values by expressions (not manually) and when i'm trying to declare them by expressions i mean for min =min(Sum(Accounts)) & max =max(Sum(Accounts)) it say's error in expression ...

So how can i declare values of min & max bounds of a mini guage by expressions ...

thanks a lot

Meher ...

[Anonymous]

Hi Merwan,

You can't use two aggregation functions like Max() or Min() and Sum() together like that. Not quite sure what you're trying to create. Do you have an example document to attach?

[#3]

Yes Johannes but there must be some other aggr function to calculate these i'm searching for them but i'm not finding any ...

thanks a lot

Meher

[Anonymous]

Sure, there's always many ways of accomplishing things. Howeer, as I'm not sure what you're trying to do I'm unable to try and help. A .qvw example file would be good for illustrating what you want.

[rwunderlich · Accepted solution]

Assume your dimension is Year. Set the max gauge property like:

max( TOTAL aggr(sum( Accounts), Year))

-Rob

[#6]

Thanx rob it worked ...