if no selection made, default to max PeriodID

[laureadiaz]

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!

[Sergey_Shuklin]

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.

[kkkumar82]

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

[laureadiaz]

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.