The index function essentially counts rows in a dataset and it can be controlled we using a partition, a concept I cover in this video along with creative ways of using the index function to achieve interesting filtering results.