Forum Discussion

jirazazabal's avatar
jirazazabal
Cloud Apps
08-11-2022

How to limit the values showed without altering values?

Hi,

We have some scenarios when we need to calculate some metrics based on all the history. For example, contribution and more. We need to include several data to get the right value. But, for example, if we have an history of 5 years, we need to perform some calculations on the whole data, but the user wants to see only the last year information. But this information is calculated by taking all the history. If I apply a filter, I'm able to see current year data, but the values are not correct, because I need all the history (for example, churn rate history). Is there a way to perform that in the widget?

Thanks!

5 Replies

Replies have been turned off for this discussion
    • jirazazabal's avatar
      jirazazabal
      Cloud Apps

      Hi harikm007 

      I've tried to do it, but in contribution, YTD... seems desn't work. I get en ERROR in the FOrmula when appling this calc, or I get no data in all the columns...

      Thanks

      • harikm007's avatar
        harikm007
        Data Warehouse

        Can you share the formula you were trying and the actual calculation you need?

        -Hari