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'` },
]
}
],
},
},
});