min gauge expression

[#1]

Hi Guys,

Went through some verfied posts and none actually have the same problem I got 🙂 Ok, so I have a gauge chart that I want to sit min and max values for.

I've used set-analysis in the expression and this is what it reads sum({1<CostCode={'Normal Time'}, Week={'2011/03/06}>}Hours)

I want my min value to be the min sum of the above constraints/criteria in my expression. So i wrote

Min(sum({1<CostCode={'Normal Time'}, Week={'2011/03/06}>}Hours) but thats not working. Any ideas on where I am going wrong gentlemen and ladies

Thanks,

Byron

[deepakk · Accepted solution]

hi Bryon,

Try this out .

Min( aggr(sum({1<CostCode={'Normal Time'}, Week={'2011/03/06}>}Hours), FieldName))

Fieldname would be the dimension based on which you want to aggregate.

[#3]

Thank you! If you read this reply thought I mght hijack my own trhead to ask a really simple question 🙂 With regards to text boxes, can with choose the direction of the text. if so where do I need to do if I want the text to be say vertically down?

Thanks

Byron

[deepakk]

hi,

In General tab of Text box select verticla scroll bar. Now reduce the width of the text box till ur text moves in vertical direction.

I think u r looking for same stuff.