Exploring Custom Functions and Formulas for Developing Gaussian Distributions in Xano
In this meeting, the State Changers discuss the issue of translating certain Excel formulas into Xano filters, specifically those that deal with normal distributions and standard deviations. The conversation revolves around how they might create a tool that allows users to plan their media campaigns over time using various distribution models like linear growth and decay or bell curves.
In the discussion, it becomes clear that the formulas in question, while easily implemented in Excel, are not readily available in Xano. They delve into what an 'average' function could look like in Xano, including iterating over a list of numbers to calculate the sum and then dividing that by the count.
They operate under the understanding that in order to get the standard deviation, one needs to understand what the mean is, as it would involve the sum of the squares of the deviations. The participant discusses their tentative idea of running three different loops - one to create the day numbers, another to create a helper column, and a third one to get the percentage.
By the end of the meeting, the group agrees that they need a clear definition of the functions used in Google Sheets in order to effectively replicate them in Xano. Nonetheless, the general feeling is positive and constructive, and homework is assigned to look into the definitions of those Sheet functions.