Reduce column-width for linear guage?

[jrdunson]

Hey, how do I reduce the column width for a linear gauge?  I've tried RTrim, LTrim, even changing my load script?

[ashfaq_haseeb]

Hi,

Can you attach sample application

Regards

ASHFAQ

[jrdunson]

Ashfaq,

I'm not sure how to do this...our tables have 921K rows...I'll have to create some fake data...and that might take a while...

I'll try

[ecolomer]

Can try push Ctrl+Caps and move elements

[Anonymous]

are there any negative values in your 921k rows?
(it Looks like that as I had the same behaviour)

try to make two Charts one for positive for for negative values

[jrdunson]

Enrique, I tried Ctrl_Caps...it doesn't do anything...

I think it has to do with leaving space, for negative amounts...? from -1 to 0 ? I'm only showing values from 0 to 1:

My Dimension is:  Division

My Expressions

1.  Sum ([Gifts Amount])

2. Sum([Gifts Amount]) / Max(Total Aggr(Sum([Gifts Amount]), [Gifts Division]))

- this follows Stephen Redmond's Cookbook... only, his example does have the wide Guage column...

[jrdunson]

Hey, I did some research and did find some negative amounts... so hm, not sure how to deal with this

[ecolomer]

Yes probably if you have negative elements the space is reserved for

[ecolomer]

For Caps+Ctrl you need table active

[jrdunson]

Tried to add set analysis to eliminate values less than zero:

From

Sum([Gifts Amount]) / Max(Total Aggr(Sum([Gifts Amount]), [Gifts Division]))

To:

Sum({$< [Gifts Amount] = {">=0"} >}[Gifts Amount] )  / Max(Total Aggr(Sum({$< [Gifts Amount] = {">=0"} >}[Gifts Amount] ), [Gifts Division]))

But my chart was unaffected .. will keep trying