I have an app with a graph connected to a SharePoint list.
every day an item is submitted for the day. Fields are:
I have 2 calculated columns which show that entry's Week start and week end.
I have a view in to display the current week's data: WeekStart>=[Today]-7 AND WeekEnd<=[Today]+7.
Basically I want to filter my graph based on the same criteria. I would like it to display the current week of data.
Something like Filter(MyData,(WeekStart>=[Today]-7),(WeekEnd<=[Today]+7))
But I think I am way off on the syntax here.
Solved! Go to Solution.