Total Modifier Question

[#1]

Hi guys,

Here is my data set.

Table1:

ID  LinkedID

1    5

4    7

1     8

Table 2:

ID    Date

1    01/02/2012

4    03/05/2014

5    08/09/2013

7    08/07/2015

8     05/04/2014

Now the chart should be like this:

ID      LinkedID      DateforID      DateForLinkedID

1        5                01/02/2012    08/09/2013

4        7                03/05/2014    08/07/2015

1       8                  01/02/2012   05/04/2014

The dimension used is

ID&LinkedID

ID

LinkedID

and expression used is

1. only(Date)

2. Pick(Match(ID&LinkedID, $(=concat(ID&LinkedID, ','))), Only(TOTAL {<ID = {5}>} Date),  Only(TOTAL {<ID = {8}>} Date), Only(TOTAL {<ID = {7}>}Date))

It gives the right chart but I cannot use the hard coded value in only(Total<>) expression because in real world there would be plenty of unknown values of linkedID . it has to be replaced by something dynamic which can produce the right value of ID for each row.

Any suggestion?

Thanks,

Saurabh

[sunny_talwar]

creating variables in the script?

[#3]

Not in the scripts but in the expressions.

BTW I am trying to hold of the scripts so I can make changes there. Not sure if I will get it but I would also love to get your suggestions for changing scripts.

[sunny_talwar]

I will be more than happy to assist you working with a script. But unfortunately I don't know of a way to create variables in bulk on the front end. or even looping through them.

You mentioned ValueMap function. I have not heard of this function before, would you be able to give an example of how it works (may be we can together get a solution for you )

Best,

Sunny

[#5]

Here is one application which has a good sue of ValueMap and Pick function.

About the script...yeah sure...

Thanks for offering the help.

The ApplyMap is one way to go but I would like to know if you have any other suggestion.

[sunny_talwar]

you meant ValueLoop

[#7]

oh Yeah