Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Carlos,
You can use your expression as a calculated dimension.
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
i wil try, i keep in touch soon.
Thanks
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