Has anyone devised a way to filter the view without filtering the data source, when the view includes a forecast? I would really like to create a forecast from several months of historical data, but I only want to see the last month plus the configured forecast period, The tried and true tricks of using lookup(min(value)) don't work as the forecasting feature won't work with table calcs, I guess.
Any thoughts?
Oh how I wish there was core method to flag a filter as a data filter (at the viz level) vs a view filter. This would have solved so many issues over the years. Explaining to a novice user, why their rolling sum is wrong and suggesting the 'lookup' hack to fix it is madness.
Yes, I’ve toyed with that… it works but is a kludge. Since the Tableau mechanism to tie into services, can only return one value per cell, I have to make that call to the R server at least 4 times to get, lower C.I., upper C.I. and forecast mean and residuals. Plus having an R server stood up just for the purpose of running RServe is not a great ‘production’ solution in my opinion. Dunno… jury is still out here. It would be great if Tableau could adopt the R integration that PowerBI has… as a datasource, as a transformation or as a visual output. That integration with the visual power and ease of Tableau would be a fantastic solution. Thanks for contributing Patrick!
