I have successfully used the corr function to calculate an R-squared value for a dimension when the dimension is filtered. I am now trying to calculate the R-squared within a tooltip for each displayed dimension in a chart. I have tried the following calculated formula, however, the tooltip shows nothing for the result:
corr({fixed [Work Unit] : min([Core Productive Hours])}, {fixed [Work Unit] : min([Volume Quantity])})
Below is a screenshot showing the tooltip with the blank RSQR value.
Any help would be appreciated.
Thanks!
