combined columns to generate bar chart

[#1]

hi every one,

i have some data like one dimension and one expression. in dimension column data is close, close1, close2, close3, close4, open,pending....etc use this data to develop bar chart. in the bar chart all close data combined to generate one bar and remaining two are two bars in bar chart is it possible. plz tell me any one urgent...       

[maxgro]

use a calculated dimension for all values starting with "clos"

=if(wildmatch(dimension, 'clos*'), 'close', dimension)

[MK_QSL]

Create a Bar Chart...

Dimension

Calculated Dimension

IF(Lower(Left(Dimension,5))='close','Close',Dimension)

Expression

As per your choice

[#4]

ok i have data like that

i have some data like one dimension and one expression. in dimension column data is close, raclose1, finished, removed, close4, open,pending....etc use this data to develop bar chart. in the bar chart all close data means(close, raclose1, finished, removed, close4) combined to generate one bar and remaining two are two bars in bar chart is it possible. plz tell me any one urgent...      

[jagan]

Hi Subbu,

In script try like this

LOAD

*,

If(Match( ColumnName, 'close', 'raclose1', 'finished', 'removed', 'close4'), 'finshed',  ColumnName)

FROM DataSource;

Now use this new column as dimension, this is the best method instead of doing this in front end.

Regards,

Jagan.

[MK_QSL]

Create a Bar Chart...

Dimension

Calculated Dimension

IF(WildMatch(dimension,'*close*','*finished*','*removed*'),'CLOSE',dimension)

Expression

As per your choice