Closed rashaduph26 closed 7 months ago
Hi,
I have encountered issues with filtering with setFilter().
url = f'https://publicstats.cbp.gov/t/PublicFacing/views/UFLPADashboardFY24JAN/UFLPADashboardFY241450?%3Aembed=y&%3AshowVizHome=no&%3Ahost_url=https%3A%2F%2Fpublicstats.cbp.gov%2F&%3Aembed_code_version=3&%3Atabs=yes&%3Atoolbar=yes&%3AshowAppBanner=false&%3AshowShareOptions=%E2%80%99false%E2%80%99&%3Adisplay_spinner=no&%3AloadOrderID=0'
from tableauscraper import TableauScraper as TS ts = TS() ts.loads(url) dashboard = ts.getWorkbook()
worksheets = [t.name for t in dashboard.worksheets]
exam_filter = dashboard.worksheets[0].setFilter('Exam Result (group)', 'Denied') data_denied = exam_filter.getWorksheet(worksheets[4]).data
After setting this filter, the data should only be one related to "Denied", but it isn't
Thanks in advance!
Hi,
I have encountered issues with filtering with setFilter().
url = f'https://publicstats.cbp.gov/t/PublicFacing/views/UFLPADashboardFY24JAN/UFLPADashboardFY241450?%3Aembed=y&%3AshowVizHome=no&%3Ahost_url=https%3A%2F%2Fpublicstats.cbp.gov%2F&%3Aembed_code_version=3&%3Atabs=yes&%3Atoolbar=yes&%3AshowAppBanner=false&%3AshowShareOptions=%E2%80%99false%E2%80%99&%3Adisplay_spinner=no&%3AloadOrderID=0'
from tableauscraper import TableauScraper as TS ts = TS() ts.loads(url) dashboard = ts.getWorkbook()
worksheets = [t.name for t in dashboard.worksheets]
exam_filter = dashboard.worksheets[0].setFilter('Exam Result (group)', 'Denied') data_denied = exam_filter.getWorksheet(worksheets[4]).data
After setting this filter, the data should only be one related to "Denied", but it isn't
Thanks in advance!