Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ...
Assume your dimension is Year. Set the max gauge property like:
max( TOTAL aggr(sum( Accounts), Year))
-Rob
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?
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
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.
Assume your dimension is Year. Set the max gauge property like:
max( TOTAL aggr(sum( Accounts), Year))
-Rob
Thanx rob it worked ...