HI,
I am struggling to get the calculation for PERCENTILE to work. When I create an extract, the calculation works, but not as a live connection.
I've also tried RAWSQLAGG_REAL, but this is an unknown function when using a live connection to Google BigQuery.
3 answers
Unfortunately this doesn't work as I get an error stating the function is "unknown" ,additionally it is not visible in the list of functions which implies that it's not possible....
I'm using Desktop v2021.4.2 (will be updated soon, but waiting for my IT department to upgrade Server).... but this command seems to have been available for a long time, so I doubt it's version related.
