Automatic Date selection

[hq_98]

Hi all,

I want to see the today() date data when i open the sheets , it should be automatically applied for the sheets , how to do it ?

Advantages of this are:- we will see the refreshed data daily without selecting today() date  on sheets.

[rubenmarin]

Hi, you can add set analysis to the expression to always show today or [max selected date] data, like:

Sum({<DateFieldNum={$(=Max(DateFieldNum))}>} Value)

Another option could be using a bookmark that selects todays date and set it as the inital bookmark of the app.

[hq_98]

Ok thank you @rubenmarin , will work on it.