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])
) - 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?
([Total Count], PREV(Months in Date Range],12)) Did the trick!
