Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Transform a expression to dimension

I need to transform this espression to dimension

if([Vta Acum]<=0.5,'A',if([Vta Acum]<=0.8,'B',if([Vta Acum]<=0.9,'C',if([Vta Acum]<=0.95,'D',if([Vta Acum]<=0.98,'E','F')))))

Regards

CAP

4 Replies
Anonymous
Not applicable
Author

Carlos,

You can use your expression as a calculated dimension.

Anonymous
Not applicable
Author

Carlos

You may wish to think about doing this in the load script and create a new field called say [VTA Group].

Best Regards,     Bill

Anonymous
Not applicable
Author

i wil try, i keep in touch soon.

Thanks

MayilVahanan

Hi

If you use calculated dimension, may be its take time to load the widgets, if you have huge data in it. So please create new field in script for tat, instead of using calculated dimension.

Hope tat helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.