Automatic selection - availability of data

[datanibbler]

Hi,

my scenario is the following:

- On the sheets of my apps, I usually implement an automatic selection of the current week (as a trigger on the button activating the
   worksheet)

<=> On some worksheets, there is no data available for the current week, or even for the current month (that is the issue I'm looking
        at right now)

=> Though correct technically, it just looks bad to see a blank chart with that "No data available" message. Seeing the data for a past
      period is not actually better, but it still makes a better impression than seeing nothing.

=> Is there some way I can set the trigger to select

- the current week if there is any data to display

- or otherwise the last week for which there is any data (might be more than one week back)?

Thanks a lot!

Best regards,

DataNibbler

[ashfaq_haseeb]

Hi,

Create a back-end field with YearWeek combination, and use MAx(YearWeek) in your trigger.

Regards

ASHFAQ

[#3]

you could achieve this with max(week).

HOpe this helps you.

regards,

MT