Hello

I have a table that stores a column "QTY" related to a Month and a Year. What I would like to get from Zoho Analytics is a chart that would reflect the Average of the "SUM(QTY") but per days of the month.

For example,. if I have the table like this

Year | Month | QTY | User

2019 | January | 10 | 1

2019 | January | 12 | 2

2019 | January | 18 |4

2019 | January | 15 | 3

The chart would be a column where QTY per day for January would be SUM(QTY)/DaysofMonth(Month)

43/31 = 1,38

So then table will contain data for February, March..... and I would like to get a column chart to reflect this "AVG" per month

This is what I call "Avg per day per month". How can I get this chart with Zoho Analytics?, is it possible?

Thanks a lot!