Filters for Formula Columns

I have a simple table where:

  • Column A represents the date companies were added.
  • Column B shows the number of companies added that date.
  • Column C calculates the 7-day moving average using a formula.

Is there a way to apply a filter to adjust the number of days in the moving average? Ideally, dashboard users should be able to switch between different periods, especially when this is visualized as a chart on a dashboard.

Hi Fern!

For this scenario I would recommend creating new calcs for the other date periods you want to show the moving average for, and then using a field control to swap out which date period is visible. You would probably also want to hide the extra fields so the vis doesn’t display all moving average calcs at once.