Data unintentionally filtered out

[Robert Eaton]

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.

[Shashank Gurnalkar]

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

filteringScheme[dataTable].ResetAllFilters()

 

# Call the function

resetAllFilteringSchemes()

[Robert Eaton]

Thanks for the response. It was an issue with the filtering in the related data tables and I ended up excluding/ignoring the filtering from the linked tabs. This resolved the issue.

 

https://docs.tibco.com/pub/spotfire/6.5.0/doc/html/filter/filter_filtering_in_related_data_tables.htm