Map / Aggretation of Values

[fs24]

Hi there,

I have an issue to solve this problem.

I have a table with transactions and a column  utm_source_source containing source of transaction (for example www.google.de, www.google.com, bing.com, cpc,... etc )). 

now i want to aggreate some values to utm_source categories  (for example www.google.de and www.google.com should show up as 'organic', and the rest as their initial value from utm_source_first

for test i made a source map in the script

Source_Map:
Mapping Load * inline
[utm_source_first, Aggregation
'www.google.de','organic'
'www.google.com','organic'
'belboon','affiliate'
];

but how i can use this source map in the expression calculation for my dimension ? i tried with a 

=ApplyMap('Source_Map',utm_source_first,'other')

but this just result into error 🙂

[marcus_sommer]

Mapping + applymap() are script-features and couldn't be used within the UI. Just load the table without the mapping prefix and you could use both fields as dimension and adding any expression like count(whatever).

[fs24]

thx for the hint. thats indeed an much easier solution 🙂