Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Create a back-end field with YearWeek combination, and use MAx(YearWeek) in your trigger.
Regards
ASHFAQ
you could achieve this with max(week).
HOpe this helps you.
regards,
MT