This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I need to calculate the 25th and 75th percentiles according to a certain formula used in Excel. Note, this is different than the normal calculation that is being utilized by the Summarize Tool. The Excel formula is as follows:
I know the LARGE and CEILING functions do not exist in Alteryx but I was curious if anyone had any ideas on how to put this Excel formula into Alteryx. I have been seeing some threads on using the Tile tool to calculate quartiles but I'm not quite sure how that works.