Ability to apply multiple Advanced Functions to same field

Richard Wolters shared this idea 2 years ago
Idea Logged

I'm looking to "stack" Advanced Functions, or put another way, apply two Advanced Functions to the same field, one after another.

In my use case, I have a field with a Percent Against Column Advanced Function already applied, and would like to then apply a Delta From Last Advanced Function against that already-applied Percent Against Column result set.

Replies (6)

photo
1

Hi Richard,

Thanks for your Idea. The Advanced Functions feature utilizes Java, so it's theoretically possible to first execute a script for Percent Against Column then apply Delta From Last, but I'm not a developer so I've no idea the effort required to actually implement it. Nevertheless, I've submitted an enhancement request for the dev team to investigate further. Any potential updates regarding this will be posted here.

Regards,

Mike

photo
1

Although I'm not a developer, I have no idea how much work would be involved in really implementing the Percent Against Column and Delta From Last scripts as the Advanced Functions feature uses Java. But, I've sent a feature request to the development team so they can look at it further. This page will be updated if there are any future developments.

photo
photo
1

Has there been any update to this?

photo
1

Hi Zack,

I haven't had an update on this one, but I'll let the developer team know you're looking to get it implemented.

Kind regards,

Chris

photo
1

Hi Zack,

Are you only looking to be able to have one function applied to another, rather than an arbitrary n level of functions? New features such as this that might require some UI changes to implement might be a little ways off.

Kind regards,

Chris

photo
1

Chris,

Primarily, I am just looking for a way to use an Advanced Function on another field that an Advanced Function has already been used. ie, "Division of columns" (af) and then the "Percentage of Total" (af) for that column. This is just a off the cuff example. I have had use cases in the past for something similar.


Thanks,

Zack

photo
1

Thanks, Zack. I'll pass the information on.

Kind regards,

Chris

Leave a Comment
 
Attach a file