https://community.databricks.com/t5/data-engineering/window-function-multiple-simultaneous-aggregations/m-p/3087#M264 <P>Hi team,</P><P></P><P>Why is there no support to perform multiple aggregations together with a single window spec? ie I dont want to specify each aggregation separately and I don't want to see each aggregation perform as a separate piece of work.</P><P></P><P>Or if there is indeed a way (other than say UDF), please do enlighten me.</P><P></P><P>Please advise.</P> Wed, 14 Jun 2023 15:01:59 GMT KarthikeyanB 2023-06-14T15:01:59Z https://community.databricks.com/t5/data-engineering/window-function-multiple-simultaneous-aggregations/m-p/3087#M264 <P>Hi team,</P><P></P><P>Why is there no support to perform multiple aggregations together with a single window spec? ie I dont want to specify each aggregation separately and I don't want to see each aggregation perform as a separate piece of work.</P><P></P><P>Or if there is indeed a way (other than say UDF), please do enlighten me.</P><P></P><P>Please advise.</P> Wed, 14 Jun 2023 15:01:59 GMT https://community.databricks.com/t5/data-engineering/window-function-multiple-simultaneous-aggregations/m-p/3087#M264 KarthikeyanB 2023-06-14T15:01:59Z https://community.databricks.com/t5/data-engineering/window-function-multiple-simultaneous-aggregations/m-p/3089#M266 <P>Hi @Kaniz Fatma​&nbsp;,</P><P></P><P>Firstly, thank you much for responding.</P><P></P><P>Thank you for confirming that performing multiple aggr using a single window spec does NOT evaluate the window spec separately each time. My bad in the wrong understanding prior.</P> Thu, 15 Jun 2023 10:00:23 GMT https://community.databricks.com/t5/data-engineering/window-function-multiple-simultaneous-aggregations/m-p/3089#M266 KarthikeyanB 2023-06-15T10:00:23Z