I just started using the SCRIPT_REAL to calculate covariance in Tableau by invoking R. Is there any way to only have the query run on only a subset of the observations? For example, the last 30 days?
I could of course use a date filter, but I want to calculate the 1-month, 3-month, and 5-month covariance so they can be displayed in the same view.
Hello Luciana Suran,
I checked in with Bora Beran and he mentioned this could be done with a filter in your R code. Let us know if you still need more assistance digging in on this. Most Tableau employees will be out of office next week at Tableau Conference so responses will be a bit slower next week.
I hope this helps.