I need a simple graph that will show me on certain values on Y axis for each day of the year.

That could be for instance total amount of deals having a certain stage. Calculating that amount is not a problem.

The problem is to have it show for every single day of the month so I can see whether the amount increases or decreases nearly in real time (it would update once every 3h).

To do that I would need Zoho Analytics to record Date of Sync. Unless there is another way to do it.

I hope I don't confuse anyone.

All I need is two values:

X axis: 01.01.2024 / 01.02.2024 / 01.03.2024 etc

Y axis: 40 000 000 / 41 000 222 / 39 222 111 etc

So the Y axis is easy, I just use Sum of certain fields based on my criteria.

But how to show that Sum for each day of the year?