Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I need help with website loading speed. If no selections are made, can I make graphs/tables default to the max Period ID?
Something with get field count I am thinking?
Thanks!
Hello!
You can use this Set Analysis condition in your expressions for getting max period when nothing is selected:
{<PeriodID = {"$(=max(PeriodID))"}>}
Or you can try to use a Bookmark with selected max period and trigger it when document is open.
Adding to the comments
Better to use Getselectedcount() for period
if(GetSelectedCount()=0,
Use the Max function as suggested above in set analysis
,
Use your function as it is with out using Period ID field in set analysis
Thanks!
Do I need to GetSelectedCount for each date field; ie. day, week, month, and year nested if style?
Also can I use this as a condition for the dimension/expression; ie, properties>dimensions>enable conditional?
I never seem to get those to work, haha.