We have a table with several records where we need to perform the moving average of the last 90 days considering only grouping by one column (fluxo_id_card).If we don't consider the rolling avarage, the calculation is performed as follows:But what happens is that we need to display these results in a month-to-month progression, where each month we view the average of the last 90 days.For the Rolling average, the basic syntax is:But we don’t have a certain number of lines that each card would occupy, and that Rows Between does not currently support the COUNT function.How can we adapt this calculation to the new context without changing the original table in the model?
Already have an account? Login
Login to the community
Sign in with your community account. This is different than your login to your GoodData account. Don't have a community login? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.