How to Dynamically update formula?

Help and How-To

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])
) - 1

The Previous 12 months is the previous 12 months that I select from the dashboard filter so say the range is from

2024-09 to 2023-10, then the previous 12 months is 2023-09 to 2022-10.

DRay Liliia_DevX do you know how to do this?

Rafael Ferreira

Posted 1 year ago·Last reply 1 year ago

6 comments

Rafael Ferreira

OP1 year ago

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

Ido Darnell

·1 year ago

MikeGre that would work, but then the period in question which is this year vs last year would be fixed in the formula.

Using the Filtered Measure plugin, the dates in question, for both the numerator and denominator, will be dynamic based off of the filters selection, respectively

Rafael Ferreira

OP1 year ago

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.