Hi AI team, any idea on when multiple references will be fully available for calculations in the analytical interface? I saw in a recent webinar that there are some workarounds with some formulas to calculate based on multiple reference fields, but with limitations on which formulas can be used, graphic visualization, etc.
Thanks for the great work!
Hi Fabio, can’t give you an exact date, but it is under active development.
There is a working draft of the changes to the formula language that will support this. It would be great to get feedback on this as we want the new syntax to be as familiar as possible to what you’re used to in other platforms.
Wow! Thanks for sharing this!
APPLY looks pretty close to DAX FILTER, which I really miss in ActivityInfo.
Will it be possible to write something like:
NONBLANK(APPLY(members, IF(_.age < 18, _.name, "")))
or NONBLANK(APPLY(members, x -> IF(x.age < 18, x.name, "")))
or COUNT(APPLY(households, household -> IF("Jordanian" IN household.members.nationality, household._id, "")))?
Also, please consider supporting Members[-1], or FIRST() and LAST() fuctions without second parameter, based on internal order of entries.
And (although this is not about lists) please add the remainder of a division to the math operators.