How to configure Daily Average Sum Calculation in Lens?

[Rafael_Mendonca (Rafael Mendonça)]

I have a "Data Table" visualization configured, where I sum the daily average of a specific value, as shown in the image below.

Now, I'm trying to recreate this view in Lens, but I can't achieve the same calculation, even using a formula.
How can I do it?

[jsanz (Jorge Sanz)]

The image was never uploaded.

Can you also share what you tried in Lens that did not work and which version?

[Rafael_Mendonca (Rafael Mendonça)]

Sorry, I updated the post with the image now.
The version of Kibana I use is 8.11.3.