# April 5, 2023: Range formulas, Pandas 2.0, Snowflake Views

## Range Formulas

Mito formulas now support ranges, unlocking a new set of use cases that were previously impossible in Mito. For example, you can now calculate a rolling average or the percent of total for each value in a column.

All of the following formulas are now possible:

* \=SUM(A:A)
* \=AVG(A:B)
* \=AVG(A0:B5)
* \=CONCAT(A0:D0)

Along with this, we've moved from the public interface v2 to v3 to ensure existing scripts don't break. Generated code will now start with `from mitsoheet.public.v3 import *`

## Pandas 2.0

Mito supports Pandas 2.0, and therefore gains a bunch of [performance improvements](https://pandas.pydata.org/docs/dev/whatsnew/v2.0.0.html#performance-improvements)! 

## Snowflake Views (Mito Enterprise)

Adds support for querying views from the Snowflake Import taskpane. 


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.trymito.io/misc/release-notes/april-5-2023-range-formulas-pandas-2.0-snowflake-views.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.