How to create rolling average using auto insights?

Question

Apart from sum and averages that automatically generate, how to use setup the rolling average or rolling sum and have insights on it using Auto insights?

WesCannon · Answer

Hi @SaiKrishna2589

You can use a Rolling Range within the Time Comparison feature of Auto Insights to create rolling averages or sums.

More detailed documentation on creating rolling ranges can be found here .

I hope this helps.

Thanks,

Wes

ScottE · Answer

Hi @SaiKrishna2589

I would use Alteryx Designer to add a rolling average and/or rolling sum to your dataset prior to loading it into Auto Insights.  Once those fields exist in your dataset, Auto Insights should be able to show trends and generate insights.

Hope that helps,

Scott