Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Dynamically select column based on slicer for regression/correlation calculation

Hi, I have approx 400 columns & thousand of rows. All column have numerical value.  My Requirement is that, Two slicers which select dynamically two different column that will represent as x & y-ax...
multiple column
Regression
Slicer
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
2 years ago

Greg_Deckler 
I'm not sure I fully understand this point. Please clarify further.
I wasn't able to try your previous suggestions today. I hope will be able to do it tomorrow. I'm so exited to finding a more simplified solution.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
2 years ago

tamerj1 Nevermind that last one, I forgot that you are using field parameters so all you will get back is the value of the parameter "Open", "Closed", etc. not the actual value for the x-axis. I think that might invalidate the previous thought I had as well. If you can't know the current value of the X-Axis then I don't think either approach will work.