Help with Date Set Analysis

[prees959]

Hi, 

I would like to make a slight change to a the "Days since Last Accessed" expression from the Governance Dashboard.

At the moment the expression is (Interval(today()-max(daystart([Session Start])),'D')) .  But is it possible to limit this to those users who only logged in last full month (eg : 01 Oct to 31st Oct) and who haven't yet logged in this month?

Many thanks 

Phil

[Stoyan_Terziev]

Hi,

Try this:

(Interval(today()-max({<[Session Start]={">=$(=TimeStamp(Monthstart(Addmonths(Today(), -1))))"}>}daystart([Session Start])),'D'))

[prees959]

Hi

Many thanks for your reply!

Thats sort of there.... its still including users that logged in this month.  Can this months users be excluded?

[Stoyan_Terziev · Accepted solution]

Hi Prees,

Try this:

(Interval(today()-max({<[Session Start]={">=$(=TimeStamp(Monthstart(Addmonths(Today(), -1))))<=$(=TimeStamp(MonthEnd(Addmonths(Today(), -1))))"}>}daystart([Session Start])),'D'))