Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Apologies if the subject makes no sense, I tried describing it the best way I could.
I have an inline load, which consists of field names which are being loaded from a different source.
LOAD * INLINE [
name,var_name,
field1,var1,
field2,var2,
field3,var3];
I also have a filter to select one from the "name" fields, for eg. the user selects field1,
AND
Lets say I have a scatter plot where the Y axis
=Only(Num#([$(=GetFieldSelections(name))]))
, which means in our example "field1" gets sent in as Y axis measure- this part works fine
I want the X axis to automatically select "var1" and use the text "var1" as the measure. This is where I am having trouble !
Having a text box with =(var_name) outputs what I need, but when i try passing the same thing as a measure in the scatter plot, it says it is not valid.
Appreciate any help !
Essentially what I want is a way to auto select the corresponding value in "var_name" based on the selection in column "name".
not just display, but actually select it - that would work for me as well