Use dimension value as fieldname in expression

[#1]

Hi.

I have a dataset that is Customer and 80+ factors from 0-1

I need to rank the top ten factors.

To do this, i have loaded the factor fieldnames into a data island called dimensions.

My theory is to create a chart and set dimension as dimension, and input the dimension value into the expression, so i get avg([value of dimension]).

Is this doable?

I attached an example.

[anbu1984]

Check this app

[anlonghi2]

Hi Jon,

try using cross table in script and rank function in expression

Attached your app with this approach (I added some extra factors to check the app)

Best regards