0

I know that one can use boolean logic operators in filters on queries, such as the following (taken from the docs):

{
  or: [
    {
      member: 'visitors.source',
      operator: 'equals',
      values: ['some'],
    },
    {
      and: [
        {
          member: 'visitors.source',
          operator: 'equals',
          values: ['other'],
        },
        {
          member: 'visitor_checkins.cardsCount',
          operator: 'equals',
          values: ['0'],
        },
      ],
    },
  ];
}

Can one also somehow use them on filters that are applied to measures? For example something along the lines of:

cube(`Orders`, {
  measures: {
    ordersCompletedCount: {
      sql: `id`,
      type: `count`,
      filters: [
          { 
              or: [
                  { sql: `${CUBE}.status = 'completed'` },
                  { sql: `${CUBE}.status = 'finished'` },
              ]
          }
       ],
    },
  },
});
Atticus
  • 147
  • 1
  • 9

0 Answers0