I have a table which shows the model name along with their r-squared values. I want to extract the model name corresponding to the highest r-squared value. I want to use this model name to use this model for further analysis purposes. Below is the snip of the table
From the table above, I am expecting to store "RF_Prediction" in another variable where I can use that in "IF" command
Other option would be:
your current search | sort 1 -r_squared
@adityagarg
Try this:
YOUR_SEARCH | eventstats max(r_squared) as max_r_squared | where r_squared=max_r_squared
This will give you model name corresponding to the highest r-squared value.