# How can I perform Windows Analytics on a dataset in Sparkflows?

**URL:** <https://community.sparkflows.ai/t/how-can-i-perform-windows-analytics-on-a-dataset-in-sparkflows/142>\
**Category:** Data Preparation\
**Created:** [December 17, 2025, 11:28am UTC](https://community.sparkflows.ai/t/how-can-i-perform-windows-analytics-on-a-dataset-in-sparkflows/142 "2025-12-17T11:28:50Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Tarika](https://avatars.discourse-cdn.com/v4/letter/t/8491ac/32.png) [@Tarika](https://community.sparkflows.ai/u/Tarika)\
**Post date:** [December 17, 2025, 11:28am UTC](https://community.sparkflows.ai/t/how-can-i-perform-windows-analytics-on-a-dataset-in-sparkflows/142/1 "2025-12-17T11:28:50Z")

</div>

In Sparkflows, we can use the ‘ **Windows Analytics** ’ processor to perform Windows Analytics on a dataset. It facilitates partitioning the dataset based on a selected column and applies windows functions such as first\_value, last\_value, lag and lead to compute value.

To use the ‘Windows Analytics’ Processor:

- Select a set of columns to partition the dataset in the **Partition By** field.
- Select a set of columns to Order dataset in the **Order By** field.
- Select **Windows Function** to be used to perform analysis.
- Select a column in **Analytics Columns**. Windows function selected would be applied to the selected column. It would be added as a new column to the output dataset.
- Enter a value for **Window Offset**. It would be used when a function is selected as **‘Lead’ or ‘Lag’**. It would determine how many backward or forward rows data would be used.

For more information read the Sparkflows Documentation here:

> **[Moving Windows Function - Data Preparation: Miscellaneous — Sparkflows 3.0...](https://docs.sparkflows.io/en/latest/user-guide/data-preparation/others.html#moving-windows-function)**
>
> Sparkflows provides various processors for Data Preparation.