Hi Team , How to replicate below sql in bigquery . select distinct [Peer Group] ,PERCENTILE_CONT(0.8) WITHIN GROUP (ORDER BY [Spend per Revenue]) OVER (PARTITION BY [Peer Group] ) AS percentile_80FROM GROUP_DATAwhere [Spend per Revenue] <= 0.0002 and...

Let say if user want to validate some data from the main source , here they are using the same filter for the data range between A and B . here as well they are trying to use like that to get particular window. so for that what can we suggest in that...

I am not able to get it what you are describing ,but for below image selection filter it will show only one day data that is 31 jan .which is issue . if we select 1st date from where boundary start it will automatically get populated which is greater...

Hi Team , I got below bug in looker analytics. while select is in range filter it is sending Wrong SQL in bigquery to fetch the data . for the range it is sending Date >= 'Some date ' and Date< 'Somedate' ,where it should be required to issue date "<...