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…

Hi @Sofia-Bourika , to achieve a moving average of the last 14 periods while presenting only the last 14 periods in your line graph in Amazon Quick Sight, you can follow these steps: Modify your Calculation: Instead of using the windowAvg function directly, you can create a custom calculated field …

Hello @Xclipse , thank you so much for the quick response. I tried to use the calculation but i couldn’t. The “rank_over” doesn’t exist as a function in Quick Sight. the only functions that exist are “Rank” and “PercentageRank” also the year_period is a string data type so i can’t do calculations w…

Hi @Sofia-Bourika , thank you for your detailed feedback and for providing information about your data fields. Given that year_period is a string and sorry, I confused rank_over with another function (if all this does not work, we may have to take a different approach with LAC-W, LAC-A ) and these exa…

Hello @Xclipse , If i will take a filter of 14 i am losing the moving avg of 14 periods that i want to display. i made a quick example in an excel [image] as you can see in the example the light blue cells are the periods and the right values i want to display. For example the last period 20250…

Hi @Sofia-Bourika , how about using windowAvg function or runningAvg function . And here is another discussion that maybe helpful. Please let us know if this approach works.

Hello @Xclipse , if you see the first comment i am using windowAvg, and is working as expected but as the picture presents [image] i need to use the “Number of data points to show:14” and sorting out in the opposite side (descending) from what i need to present the data as you can see in the pi…

Hello, i just created the Moving AVG in Quick Sight Arena Moving AVG Much appreciated your help, Thank you

Hi @Sofia-Bourika , sorry for the delay, can you try this, is the calculation correct? I filtered 1 thru 14. Moving AVG - Analysis Filter on Line Graph 1 thru 14 Please tag @Xclipse , so I can get notified when you respond. [2024-05-14_20-19-28]

Hello @Xclipse , Don’t worry that’s fine for your delay :slight_smile: So if you filter from 1 to 14, the calculation is not correct. [image] check from these 2 tables, the correct values are in the table “Last 28 Periods” while the last 14 periods are wrong. I updated the Analysis with the tabl…

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 quick-sight , calculations , Business-Intelligence-Engineer	4	107	February 9, 2025
Moving media for beginner Q&A analysis , quick-sight , visuals , calculations , visual , Business-Intelligence-Engineer	7	251	January 12, 2024
Moving average Q&A analysis , quick-sight , calculations , Business-Intelligence-Engineer	2	139	February 9, 2025
Moving_average Q&A quick-sight , calculations , Business-Intelligence-Engineer	8	809	November 15, 2023
Rolling average using windowAvg at the edge of the range of filtered data Q&A analysis , quick-sight , visuals , calculations , Business-Intelligence-Engineer	8	811	February 7, 2025

Moving AVG

Related topics