Aggregation logic for filters + median value of row values

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?

Hi @jim_measured

Based on your requirements, LAC-A functions should allow you to represent your data in the way you want. With LAC-A functions, you can group the computation on a level you select. If we presume you are using columns Date, Company, Spend, Flag, a possible example is median({Spend},[Flag]).

Did this solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community!