Ideas for additional filter options

[kdengler]

Problem description

It would be great to implement additional filter options in Pivot (and other?) filter widgets, table filters etc. to use filters more dynamically and manage higher amounts of elements. See below for ideas.

Text filter options

• equal (?)
• not equal
• begins with
• begins not with
• ends with
• ends not with
• contains
• contains not

Examples from Excel

Numeric filter options

• equal (?)
• not equal
• higher than / higher or equal
• lower than / lower or equal
• between
• top x
• bottom x
• top x %, element-based (percentiles) & value-based*
• bottom x %, element-based (percentiles) & value-based*
• (above average)
• (below average)

* Example: Of 80 stores, those with the highest sales should be filtered:

1. top 25 % element-based: the 20 stores with the highest sales
2. top 50 % value-based: the stores with the highest sales, which together account for at least 50% of the total sales volume of all stores

Example from Excel

Advanced Ideas

Additional Filter options for cubes

In dimension hierarchies:

• n-th level (from top)
• bottom level

Combine multiple by AND / OR, nested filters

Example from Excel (only 2 combinable filters):

Using regular Expressions in Text filters

• like
• not like

Code line for advanced users

... to write more complex/nested filters manually

Example from QGIS (here with UI support & based on SQL):

Preferred solution

No response

Are you interested in contributing a solution yourself?

None

Alternatives you've considered

No response

Anything else?

No response

[kdengler]

I added filter ideas for cube dimensions/hierarchies and a numeric bottom/top x % filter.