Set Analysis Rolling Period

[#1]

Hi Experts,

I have created a dashboard. My requirement is want to show Last 15 Days Sales.

My expression is like this:

Sum({<Year=, Quarter=, Month=,Week=,  TransactionDate={'>=$(=DayStart(Max(TransactionDate), -14))<=$(=Max(TransactionDate))'}>} Sales )

But am getting overall 31 Days. Please help me how to achieve this

Thanks in Advance

[gautik92]

have a look at this

Set Analysis for Rolling Periods

[SreeniJD]

Try this -

Last 15 Days Sales

Sum({<Year=, Quarter=, Month=, Week=, TransactionDate={‘>=$(=Date(Max(TransactionDate)-14))<=$(=Date(Max(TransactionDate)))’}>} Sales )

HTH

Sreeni

[#4]

Its not working

[avinashelite]

can you please share the app and sample data

[SreeniJD]

Hey Abhi

Is your date in proper format.. if not use Date# function to covert into required date format.

or else attach a sample application, which will help us to provide quick solution for you

Sreeni

[ecolomer]

Try without week=

Sum({<Year=, Quarter=, Month=, TransactionDate={'>=$(=DayStart(Max(TransactionDate), -14))<=$(=Max(TransactionDate))'}>} Sales )

[#8]

Hi,

Please find attached Sample application.

Thank You, !

[tresesco · Accepted solution]

Try:

Sum({<Year=, Quarter=, Month=,Week=, TransactionDate={'>=$(=Date(Max(TransactionDate) -14))<=$(=Date(Max(TransactionDate)))'}>} Sales )

If you don't see, last 15 days data here, that is because you don't have data for those dates.

[Anonymous]

Hi,

If you don't have data for last 15 days obviously you don't see any data. First check your data whether you have transactions on those days or else below expression works.

Try this:

Sum({<Year=, Quarter=, Month=,Week=, TransactionDate={'>=$(=Date(Max(TransactionDate) -14))<=$(=Date(Max(TransactionDate)))'}>} Sales )

Hope it helps!!