Set Analysis and Set Expressions

[botlhokots]

Hi all,

I have measure AVG(Offload_TAT)

I want to include a set expression on a dimension or filed WEEKNUM which displays the week numbers, I want to use it to return the previous 3 weeks excluding the current one.

For example if we WEEKNUM = {35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45} I want to use only {41, 42, 43, 44} only>

Use that in a set expression for my chart please.

[Kushal_Chawda]

@botlhokots  If you have Date field in your data try below

AVG({<Date ={">=$(=weekstart(max(Date),-4))<=$(=weekend(max(Date),-1))"}>}Offload_TAT)