Forum Discussion

ManuelEspitia's avatar
ManuelEspitia
Icon for Helper II rankHelper II
6 years ago
Solved

Covid Colombia Moving Average

Hello

How can I get a 7-day moving average with a table that has many records per day in the date column, that is, many rows for each day of the date? I've watched all the YouTube videos but it doesn't work for me in any way. I guess it's that detail. I haven't managed to find an example like the one I'm trying to figure out. Help!

Thank you 😉

  • dax's avatar
    dax
    6 years ago

    Hi ManuelEspitia , 

    You could try to use built-in expression(rolling avg) or use your custom expression. You could refer to my sample for details.

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

2 Replies

  • dax's avatar
    dax
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi ManuelEspitia , 

    You could try to use built-in expression(rolling avg) or use your custom expression. You could refer to my sample for details.

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.