Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
use a calculated dimension for all values starting with "clos"
=if(wildmatch(dimension, 'clos*'), 'close', dimension)
Create a Bar Chart...
Dimension
Calculated Dimension
IF(Lower(Left(Dimension,5))='close','Close',Dimension)
Expression
As per your choice
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...
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.