topic Set analysis/Set Expression in App Development

Set analysis/Set Expression

botlhokots — Mon, 11 Nov 2024 06:36:24 GMT

Hi all,

I hope all is well.

Please assist in building in a set expression to pull the last 3 months in a measure.

The measure is Avg(OFFLOAD_TAT), and the date field in format "2024-09-01 05:30:00.000000" called DropArrive

Re: Set analysis/Set Expression

sk88024 — Mon, 11 Nov 2024 06:58:13 GMT

May be this:

rangesum(above(Avg(OFFLOAD_TAT),0,3))

If not, you can provide some sample data with output examples for more clarity.

Re: Set analysis/Set Expression

botlhokots — Mon, 11 Nov 2024 07:12:38 GMT

Avg({<Contract= {'Invoiced'}>} OFFLOAD_TAT)

Using this example where I put in a condition for Contract. I want to do the same for the Date Field and returning the last 3 months.

Re: Set analysis/Set Expression

sk88024 — Mon, 11 Nov 2024 07:23:49 GMT

Try this:

Avg({$<Date={">=$(=MonthStart(AddMonths(Today(),-4))) <$(=MonthEnd(AddMonths(Today(),-1)))"}>} OFFLOAD_TAT)

=Avg({<Date = {">$(=Max((Addmonths(Date,-3)))) <$(=Max (Addmonths(Date)))"}>} OFFLOAD_TAT)