I am struggling to create the right filter logic that interacts with how I wish to represent my data.
- I have rows of advertising spend by company
- I have a flag column that segments those advertisers into tertiles
- I want to create a table that returns the median spend for advertisers in a specific tertile.
- My data is time series, and I believe the problem may be that it is aggregating to the median value across individual time periods, not the aggregate time period I am looking for.
Can someone provide guidance?