Forum Discussion

Abz_17's avatar
Abz_17
Helper 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
Helper 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
    Super 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
      Helper 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