Hi,
I'm trying to create a table to go on a dashboard. I have a date filter on the dashboard that applies to several sheets, so whoever is viewing it can change the date on the dashboard themselves and see how data changed for each date.
For one of the tables, I have average data for different metrics (total distance, no of sprints etc) in the columns section.
I would like to add another line of data below this that shows the average data for each metric for the year (effectively ignoring the date filter that's been applied to the sheet).
How can I do this?
3 answers
use this:
{AVG(Your Value)}
or you can use this
{AVG(if your year=2020 then Your Value end)}
This value would never change with any filter.
