Aggregate awareness - filter values

[xavier_bourret_]

Do you know of a way to include multiple values in the filter of an aggregate awareness table, and get looker to interpret it in a smart way? i.e. trigger the aggregate table for subsets of the filter values, rather than an exact match ?

Example: if I have this particular aggregate awareness setup, it will only trigger if my explore has exactly A,B,C selected and filtered, in that exact order. If I select A or B, or A,B etc. it won't trigger

  aggregate_table: rollup_1_xbs{
    query: {
      dimensions: [
        table1.dimension1,
        table2.dimension1,
        table2.dimension2
      ]
      measures: [
        total_a,
        total_b,
        total_c
      ]
      filters: 
I have found a hack around this which is to create a new custom dimension which is defined as
dimension: partitions_manualsql: CASE WHEN ${partitions} IN ('A', 'B', 'C') THEN 'yes' ELSE 'no' END;;
Setup my awareness table as
filters: [partitions_manual: "yes"]
and then I can select that filter in the explore and it will work.
However this isn't optimal for the end user for a number of reasons which I won’t go into; isn't there a way to tell Looker otherwise ?