Jump to content

Data unintentionally filtered out

Robert Eaton

Recommended Posts

I am working on a dxp document with several tabs. On two of the tabs I only am receiving a small portion (ie 10%) of the data in the visualization. I have cleared all filters and checked data canvas for any additional filters and all filters have been removed however it still states at the bottom right of the document that filtered rows are 20 of a total number of 200 rows. Any suggestions on how to fix this. BTW I have reloaded all the data with no luck.
Link to comment
Share on other sites

It could be that the visualizations(s) in those two tabs using a different filtering scheme that the current filtering scheme from the page (default) which you can check in Properties >> Data Limit data using filterings. If so, check the first option in it and uncheck the rest and test it again.

Or you can also try to execute the following IronPython script which will reset all the filters of all the filtering schemes and see if this helps.

from Spotfire.Dxp.Data import *

from Spotfire.Dxp.Application.Filters import *


def resetAllFilteringSchemes():

# Loop through all filtering schemes

for filteringScheme in Document.FilteringSchemes:

# Loop through all data tables

for dataTable in Document.Data.Tables:

# Reset all filters



# Call the function


Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...