topic help in set analysis in App Development

help in set analysis

ali_hijazi — Fri, 14 Jun 2019 14:49:35 GMT

Hello got a pivot table with several dimensions and 2 expressions

the first expression calculates the average planned man-days between 2 fixed dates (calculated)
now the second expression should calculate the average planned man-days between date 1 and date 2 where date 1 is fixed but date 2 is calculated by an expression

Check images:

so in the first line the 4.2 is calculated as avg({<month_year={">=june 2019 <= sep 2019"}man_days)
but now I don't have sep 2019 I need to use the to_date calculated in the last column
kindly advise

Re: help in set analysis

Lauri — Fri, 14 Jun 2019 19:25:30 GMT

Put the formula that caclulates to_date in place of 'sep 2019' and inside $( ) so something like:
avg({<month_year={">=june 2019 <= $(=formula)"}>} man_days)

Re: help in set analysis

ali_hijazi — Sat, 15 Jun 2019 19:26:55 GMT

the $(Formula) here in this case should be one single value
however the "formula" is actually a table, so your suggestion doesn't work

I will try to make an aggregation and make a check using if else statement