Create your own statistcal functions

VisionBI | Jurgen shared this question 7 months ago
Answered

I want to create my own function that can calculate like Mean/Median/etc. does. So it has to calculate over the given set.


When I now use R in Transformation Flow, it calculates line by line. How could have an R function over the given set? (for instance to calculate quartile).

When creating a query (report) I can use the advanced functions and use the mean, median, etc. They calculate over the given set. Can I create my own functions like these? Is it also possible to see the code that is used to create these functions (like custom-functions.xml).

Comments (2)

photo
1

Hi Jurgen,

I provided an answer to this in another very similar sounding ticket. Have you received that?

Nathan

photo
1

Hi Jurgen,

I am going to close this ticket, but please let me know if you would like to continue the conversation on this.

Nathan