Set analysis - show only last 12 weeks data

[#1]

Hi!

I'm a newbie to Set analysis but is finding it very hepful, specially when designing dashboards where I don't want the users to make selections.

I want one of my charts in the dashboard to only show the trends for the last 12 weeks. But my set expression doesn't seem to work for me.. I need some of your expert help 🙂

My date format in the application is YYYYMMDD as you see below. This expression gives back current selections instead of giving only dates larger than the start of week twelve weeks ago.

Cheers,

Max

sum

( {$< Date = {">=$(=date(#weekstart(Today(),-12),'YYYYMMDD'))"} >} StdTime)

[#2 · Accepted solution]

Hi Max,

see the attached example.

Good luck!

Rainer

[#3]

Thanks for the quick answer, Rainer. Much appreciated!

Max week in the application isn't current week, unfortunately.. Otherwise it would have been what I wanted!

I did a couple of tests again and without the "#" it looks like it's working! Maybe I was a bit quick to consult the forum 😛

sum

( {$ < Date = {">=$(=date(weekstart(Today(),-12),'YYYYMMDD'))"} > } StdTime)