Forum Discussion

Astroraf's avatar
Astroraf
Data Pipeline
05-21-2025
Solved

How to Dynamically update formula?

I am trying to create a formula that dynamically changes with the dashboard filter that I set.  The formula is: ( ([Total count], [@Months in Date Range]) / ([Total count], [@Previous 12 Months]...
Code-first Analytics
dashboards & reporting
  • Astroraf's avatar
    Astroraf
    05-27-2025

    ([Total Count], PREV(Months in Date Range],12)) Did the trick!

Astroraf's avatar
Astroraf
Data Pipeline
05-27-2025

The problem with this solution Ido_QBeeQ is that this only works with Elasticubes. I am working with a live model, and MikeGre , this solution sounds like it would work because even if they are picking months, they are always looking at the year range, but when applied, I get no data. Will have to look further into this.

Ido_QBeeQ's avatar
Ido_QBeeQ
ETL
05-28-2025

Astroraf I think it should still work, will check and let you know, happy to hear you solved your challenge!