Skip navigation

Percentile function on LIVE connection

score 9
You have not voted. Active

Hi Guys,

 

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?

 

Phil

Comments

Vote history