Spotfire Ideas Portal
Add a new idea Subscribe
Status Future Consideration
Product Spotfire
Categories Data Management
Created by Guest
Created on Sep 22, 2016

RELATED IDEAS

Combination of filters using and, or, xor, not etc.

In many cases it is useful to have a filter where a row filtering should depend on two columns.

An example would be to select all rows with country equal to UK or Year before 2010.

This is currently not possible without using a calculated column which is less flexible.

  • Attach files
  • Guest
    Reply
    |     May 22, 2018

    I think there are two concerns here:

    1. There is no XOR in logical expression, and to achieve it would be writing a much more hefty case statement.
    2. Want to avoid overloading calculated columns with a logical expression where possible - such a column may be meaningless to many other visualization tabs; however, per visualization may be too repetitive to implement, if there are multiple panels that should have the same logic either.
  • Admin
    Tobias Lehtipalo
    Reply
    |     May 18, 2018

    You can create more complex filter conditions by inserting a calculated column with a logical expression.  E.g. if you add a column with the following expression ([Department]="Finance") Or ([Employee Status]="Contractor") you will get a filter with the values true or false that allow you to filter out or filter in all rows that satisfies your condition. 

    It´s also possible to limit what is shown in a specific visualization by using a logical expression similar to the one above. 

  • Guest
    Reply
    |     May 18, 2018

    Yes this would be nice and it would be great to be able to switch between AND and OR.   Users sometimes want to see when all filter  conditions are true rather than if any are true.

  • Guest
    Reply
    |     Sep 22, 2016

    I'd love to have this. So many times we need to filter out only a specific combination (e.g. filter out device 4 but only on board 2)

This document (including, without limitation, any product roadmap or statement of direction data) illustrates the planned testing, release and availability dates for Spotfire products and services. It is for informational purposes only and its contents are subject to change without notice. Planning to implement - generally 6-12 months out. Likely to Implement - generally means 12-18 months out. Copyright © 2014-2023 Cloud Software Group, Inc. All Rights Reserved. Cloud Software Group, Inc. ("Company") follows the EU Standard Contractual Clauses as per the Company's Data Processing Agreement. Terms of Use | Privacy Policy | Trademarks | Patents | Contact Us