Set Analysis and Set Expressions

botlhokots — Mon, 11 Nov 2024 08:00:19 GMT

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.

Re: Set Analysis and Set Expressions

Kushal_Chawda — Mon, 11 Nov 2024 09:22:42 GMT

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

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

topic Set Analysis and Set Expressions in App Development

Set Analysis and Set Expressions

Re: Set Analysis and Set Expressions