Hello, I am trying to create the moving average of the last 14 periods the calculation i am using is: windowAvg(sum({earning}),[{year_period} ASC],14,0) In my visual (a line graph) i need to present only the last 14 periods. However if i will add a filter of the 14 periods the calculation is bre…

Hi @Sofia-Bourika , thanks for the detailed explanation – so, it’s a visualization adjustment using “off-visual field” for sorting, then adjusting the X-axis “Number of data points to show,” set to 14 or 15. As shown below. Period Year Sorting Calculation ifelse({year_period}=202401,100,ifelse({yea…

Moving AVG

Q&A

Xclipse May 7, 2024, 9:05pm 8

@Sofia-Bourika, please can you try to provide an example in the Quick Sight Arena, so I can try out different methods. In the meantime, you can try using off-visual metric sorting.

Topic		Replies	Views
Moving average for small period Q&A calculations , Business-Intelligence-Engineer	4	91	February 9, 2025
Moving media for beginner Q&A analysis , visuals , calculations , visual , Business-Intelligence-Engineer	7	241	January 12, 2024
Moving average Q&A analysis , calculations , Business-Intelligence-Engineer	2	126	February 9, 2025
Moving_average Q&A calculations , Business-Intelligence-Engineer	8	801	November 15, 2023
Rolling average using windowAvg at the edge of the range of filtered data Q&A analysis , visuals , calculations , Business-Intelligence-Engineer	8	777	February 7, 2025

Moving AVG

Related topics