MicroStrategy ONE

ApplyComparison

You can use the ApplyComparison function to define custom filters. The ApplyComparison function is used with comparison operators such as >, Like, and In. This is a comparison function.

Syntax

ApplyComparison()

Accepts facts, attributes, and metrics as input.

Example 1

ApplyComparison ("#0 between #1 and #2",? [Value Prompt Date], [Order Date]@ID, [Ship Date]@ID)

Example 2

ApplyComparison ("#0>#1", Store@ID, Month@ID)