Crossover Sales Report

This is awesome, thanks Chris! How can I exclude the -999999 constituent ID from the advanced attribute filter? 

Two approaches Gabrielle,

We can use a field other than Constituent ID that will remove that -999999 placeholder. For example, CONSTITUENT Type will equal (none) on that constituent,

so setting another filter on your dashboard or widget that excludes only (none) will pair well with your attribute filter.

Alternatively, just because this is handy to know, advanced filters support getting pretty dense with nested AND / OR groupings, generally formatted as

{ 
 "or":[ 
   { 
   //critera1//
   },
   { 
   //critera2//
   }
 ]
}

To uncover the advanced code for any given standard filter, you can click from the desired filter to the Advanced tab and lift the code from there. For example, for Constituent ID <> -999999.

 ===> 

Assembling an AND filter on Constituent ID with the attribute bits from my previous post might look like this:

{
  "and": [
    {
      "attributes": [
        {
          "dim": "[PERFORMANCE DETAIL.Production Season]",
          "filter": {
            "members": [
              "Chicago 2020"
            ]
          }
        }
      ]
    },
    {
      "explicit": false,
      "multiSelection": true,
      "exclude": {
        "members": [
          "-999999"
        ]
      }
    }
  ],
  "custom": true
}

Oh the Pandora's box you just opened in my brain. 

Oh the Pandora's box you just opened in my brain.