2 Replies Latest reply on Dec 19, 2016 1:46 PM by Steve Ware

    Forecasting and filtering

    Steve Ware

      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.