I am trying to perform the Percentile function when creating a calculated field, however my other requirement is that the connection to the database is live.
I am connecting to a microsoft sql server, however can only get the Percentile function to become available when using an extract. In live, I can only use window_percentile which gives inconsistent results.
I also noticed that median function also does this.
Can we please get the percentile function for live connections to a sql server?