The following tables list the members exposed by SpecialFilterOperands.
Name | Description | |
---|---|---|
![]() ![]() | AboveAverage | An operand used to determine if a specified value is above the average of the set of values of which the value being tested is a member value. |
![]() ![]() | April | An operand representing the fourth month of the year. |
![]() ![]() | August | An operand representing the eighth month of the year. |
![]() ![]() | BelowAverage | An operand used to determine if a specified value is below the average of the set of values of which the value being tested is a member value. |
![]() ![]() | Blanks | An operand used to determine if a specified value is blank ('null', 'dbnull' or empty string). |
![]() ![]() | Bottom10 | An operand used to determine if a specified value is one of the bottom 10 values in the set of values that the value being tested is a member of. |
![]() ![]() | Bottom10Percentage | An operand used to determine if a specified value is one of the bottom 10 percent of the values in the set of values that the value being tested is a member of. |
![]() ![]() | December | An operand representing the last month of the year. |
![]() ![]() | February | An operand representing the second month of the year. |
![]() ![]() | January | An operand representing the first month of the year. |
![]() ![]() | July | An operand representing the seventh month of the year. |
![]() ![]() | June | An operand representing the sixth month of the year. |
![]() ![]() | LastMonth | An operand used to determine if a specified value is between the first and last days of last month. |
![]() ![]() | LastQuarter | An operand used to determine if a specified value is between the first and last days of the previous quarter. |
![]() ![]() | LastWeek | An operand used to determine if a specified value is between the first and last days of last week. |
![]() ![]() | LastYear | An operand used to determine if a specified value is between the first and last days of the previous year. |
![]() ![]() | March | An operand representing the third month of the year. |
![]() ![]() | May | An operand representing the fifth month of the year. |
![]() ![]() | NextMonth | An operand used to determine if a specified value is between the first and last days of next month. |
![]() ![]() | NextQuarter | An operand used to determine if a specified value is between the first and last days of next quarter. |
![]() ![]() | NextWeek | An operand used to determine if a specified value is between the first and last days of next week. |
![]() ![]() | NextYear | An operand used to determine if a specified value is between the first and last days of next year. |
![]() ![]() | NonBlanks | An operand used to determine if a specified value is not blank (anything that's not 'null', 'dbnull' or empty string). |
![]() ![]() | November | An operand representing the eleventh month of the year. |
![]() ![]() | October | An operand representing the tenth month of the year. |
![]() ![]() | Quarter1 | An operand used to determine if a specified value falls within the first 3 months of the calendar year. |
![]() ![]() | Quarter2 | An operand used to determine if a specified value falls within the second 3 months of the calendar year. |
![]() ![]() | Quarter3 | An operand used to determine if a specified value falls within the third 3 months of the calendar year. |
![]() ![]() | Quarter4 | An operand used to determine if a specified value falls within the last 3 months of the calendar year. |
![]() ![]() | September | An operand representing the ninth month of the year. |
![]() ![]() | ThisMonth | An operand used to determine if a specified value is between the first and last days of this month. |
![]() ![]() | ThisQuarter | An operand used to determine if a specified value is between the first and last days of the current quarter. |
![]() ![]() | ThisWeek | An operand used to determine if a specified value is between the first and last days of this week. |
![]() ![]() | ThisYear | An operand used to determine if a specified value is between the first and last days of the current year. |
![]() ![]() | Today | An operand used to determine if a specified value is equal to today's date. |
![]() ![]() | Tomorrow | An operand used to determine if a specified value is equal to tomorrow's date. |
![]() ![]() | Top10 | An operand used to determine if a specified value is one of the top 10 values in the set of values that the value being tested is a member of. |
![]() ![]() | Top10Percentage | An operand used to determine if a specified value is one of the top 10 percent of the values in the set of values that the value being tested is a member of. |
![]() ![]() | YearToDate | An operand used to determine if a specified value is between the first day of the year and the current date. |
![]() ![]() | Yesterday | An operand used to determine if a specified value is equal to yesterday's date. |
Name | Description | |
---|---|---|
![]() ![]() | CreateDateRangeOperand | Creates an operand used to compares dates to a range of dates based on a given relative date and the granularity to which the dates should be compared (e.g. compare the year). |
![]() ![]() | GetBuiltInOperand | Gets the built-in special filter operand of specified name. |
![]() ![]() | GetRegisteredOperand | Returns the registered operand with the specified name. If no operand with the matching name is found, returns null. |
![]() ![]() | GetRegisteredOperands | Overloaded. Returns all registered operands. |
![]() ![]() | Register | Registers a user defined special operand. This method can be used to re-register built-in special operand as well, in case it was un-registered with Unregister method. |
![]() ![]() | Unregister | Un-registers a previously registered operand. Built-in operands can also be un-registered. |