Moving Calculations are ideal for analyzing data sets that fluctuate a lot. Be it stock prices, temperature, or daily sales trend, moving calculation allows you to identify the trend. It smoothens the noise of the random short-term fluctuations from your report.
In moving calculations, the value for each data point will be calculated over a specified time frame. For example, you are calculating a moving average over your stock price and have set the window as 10 days. Now your chart plots the 10days average stock price for each data point. Zoho Analytics supports moving calculations and also allows you to change the time frame in your report dynamically using Variables.
This week, let's see how to create moving calculations with dynamic window.
Zoho Analytics supports the following window calculations .
Variables are placeholders that can be used as input, and can be changed on the fly. They enable dynamic input parameterization for various operations. With variables, you can set a dynamic window for your moving calculation.
To create a variable,
The variable is created. Now, we can use this to input a dynamic window for the moving calculation.
Follow the steps to create a chart with moving average with dynamic window.
Now, let's see how to calculate a moving average with a dynamic window.
window_function( Aggregate Expression, Start, End ) |
The following formula calculates the moving average of the stock price with a dynamic window.
window_avg(avg( "index Prize"."Open" ), ${Window Range} , 0 ) |
The formula is created. Now it can be used in the report.
Now let's create the moving average chart.
https://analytics.zoho.com/workspace/1160261000007432001
Stay tuned to learn about more calculations.
Writer is a powerful online word processor, designed for collaborative work.