How to set expression to check the last 30 days?

[bhaveshp90]

Hello,

How Can I set the expression to my date column, so that it will filter only for the Last 30 days?

[marinadorcassio1]

You should add a set analysis in your differents expressions in order to filter on the last 30 days.

Hope it helps,

Regard,

Marina

[sudeepkm]

something like below:

sum({<[Year Field]=,[Month Field]=, [Your Date Field]={">=$(=Date(Today()-30))<=$(=Today())"} >} SalesVolume)

[bhaveshp90]

I have added this expression but I am unable to get the last 30 days data

Sum({<Snapshot_Date = {">=$(=Addmonths(Max(Snapshot_Date),-1))"}>}Go_Live)

[sunny_talwar]

What is the format for Snapshot_Date?

[dplr-rn]

whats the dimensions in your chart?

if it has Snapshot_Date as a dimension the expression will not work

[bhaveshp90]

The format for Snapshot_Date is  '2018-08-31'

[bhaveshp90]

I have Project Number as the Dimension and PAC Delay as Expression. I do not have Date in my Dimension 

[sunny_talwar]

Try this

Sum({<Snapshot_Date = {">=$(=Date(Addmonths(Max(Snapshot_Date),-1), 'YYYY-MM-DD'))"}>} Go_Live)

[dplr-rn]

What is the output that you are getting