My problem is that I need to create a calculated dimension that depending on the value of an expression (one Sum ) to calculate corresponding section the result of that expression.
Explained in more detail , I have many outlets , and within each of them ( and depending on the current selection ) I have to do that units sent to you and depending on your service has to go to a section or other service . A point of sale is a section of Service .
I can not calculate the Script -level sections , because it depends on the selection.
A sample output would look something like the image attached.
This result was achieved with the following expression , but the problem is that it is not optimal because the existing information takes a long time to load (2-3 minutes on the Windows client , Web- not even opened) .
Aggr ( If ($ ( vAuxTramoServicio ) = 1, 1, If ($ ( vAuxTramoServicio ) = 2 , 2 If ($ ( vAuxTramoServicio ) = 3,3 , if ( $ ( vAuxTramoServicio ) = 4,4 , if ( $ ( vAuxTramoServicio ) = 5,5 , if ( $ ( vAuxTramoServicio ) > = 6 And $ ( vAuxTramoServicio ) < = 10 , '6 to 10 ' , if ( $ ( vAuxTramoServicio ) > = 11 And $ ( vAuxTramoServicio ) < = 25 , ' 11-25 ' , if ( $ ( vAuxTramoServicio ) > = 26 And $ ( vAuxTramoServicio ) < = 50 , '26 to 50' , if ( $ ( vAuxTramoServicio ) > = 51 And $ ( vAuxTramoServicio ) < = 100 , '51 to 100 ' If ($ ( vAuxTramoServicio ) > = 101, ' Over 100 ' )))))))))) , CLAVE_PUNTO_VENTA , COD_NUMERO )
vAuxTramoServicio is
Sum ( { < [ ESTADO_PUNTO_VENTA ] = {' end '} >} NUM_ENTREGADOS + NUM_COMPLEMENTOS )
I tried an alternative , but I can not work any .
ApplyMap First I tried , but I 've noticed that this function only works in Script , because the Load Mapping are deleted when the script ends .
I uploaded some Excel with mapping of each of the possible outcomes that correspond stretch , but I have not got the expression that works.
I tried with FieldValue and FieldIndex , but the problem is that FieldValue are different values , so I can not get the correct index to get the value it deserves. I mean for example if the service is 8, not service takes the stage 8 , but the 8th value TramoServicio .
