Text function inside $map function to customize dynamic naming of columns

[Luke George]

I have a line chart with multiple columns (dynamically selected) on the Y-axis. I am using the below custom expression to name the columns on the X-axis:

$map("Avg($esc(${ElementsSpider1})) as $esc(${ElementsSpider1})", ",")

Is there any way to also use a text function in this expression to further customize the naming Somthing like this for example:

$map("Avg($esc(${ElementsSpider1})) as Split($esc(${ElementsSpider1})," ",1)", ",")

[Gaia Paolini]

can you post a sample dxp with what you have done 

[Luke George]

Hi Gaia,

I've attached a simplified dxp as an example. As you can see, there are two line plots with normalisation and display elements chosen dynamicallywith document properties. I would like to remove the integer after the element name on the x-axes column labels(e.g., change "Si 2" to "Si).

[Luke George]

Hi Gaia, I've posted a dxp example below.