Forum Discussion

Abz_17's avatar
Abz_17
Icon for Helper I rankHelper I
3 years ago
Solved

Rolling 7 Days Average

Hi All,    I have a dataset which starts on 4th Jan 2021. What I want to do is show the rolling 7 day average for each of these dates so for example 12/02/2023 i want to know what the average has b...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
Abz_17's avatar
Abz_17
Icon for Helper I rankHelper I
3 years ago

Hi, I tried the solution but am getting this error

 

says it cant display visuals due to the error above. Is it to do with my data? Or something else?

miTutorials's avatar
miTutorials
Icon for Super User rankSuper User
3 years ago

Are you using the Primary date column from the table ? Do you have this table connected to a calendar table ?

  • Abz_17's avatar
    Abz_17
    Icon for Helper I rankHelper I
    3 years ago

    I am using the date column from my table. I dont have a calendar table involved. Data set looks like this