Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to set dynamic default bookmarks with 'always one selected value' on a field? For example, in a date field set to a variable with current fiscal period. =DateField=$(vCurrentFiscalPeriod) works well when always one selected value is not set for field, but does not work at all when set for field using this method https://www.youtube.com/watch?v=tFyqOigqnUw.
Is there a way to achieve this without using extensions? I'd like to avoid installing 3rd party extensions without support as they may not work with upgrades.
Did you manage to do this with alternate states?
I have the same problem as you. I have an app where I need to have one year selected, but I also want to dynamically set the latest year by default.
I looked into alternate states, but they seem to be designed to be used for grouping up some filters with visuals, and I don't see how they can be used to solve this problem.
facing the same problem.
any help welcome
I went another route with this by enabling multiple selections and making charts conditional to one selected. Not as desirable, but accomplishes the goal.
Did you ever manage to find a more decent solution for this? I am facing with the same issue.
Cheers
anyone got better alternative?
It used to work for us, not 100% but after upgrade to June 2020 we don't see latest month when data is refreshed.
I have bookmark created using this expression in the filter pane - =[Month Year]=Max({1} total [Month Year])
Solution which works for me is to create a bookmark expression: =Only({1}Year) = Max({1}TOTAL Year). This way the expression ignores the selected Year value and picks the actual max Year. It is important to create the dynamic bookmark before changing the field setting to Always one selected value, otherwise the bookmark will evaluate the expression and bookmark will be static.
Tanks for the tip @eero_h. It works fine.
Yes. This solution did the trick for me too. Fantastic suggestion. Thank you.