tableau / extension-data-driven-parameters

Automatically update your parameters based on your data!
https://tableau.github.io/extension-data-driven-parameters/
MIT License
18 stars 18 forks source link

Unable to select from list #14

Closed JohnDelahunt closed 5 years ago

JohnDelahunt commented 5 years ago

When I select a value from the list in the Data-Driven Parameters extension three things happen:

  1. The parameter is changed to the selected value
  2. The list is re-loaded
  3. The parameter is reset to the first item in the list.

Is it possible that I have something set so as to trigger this behavior? Any help would be appreciated.

JohnDelahunt commented 5 years ago

Through testing, I have discovered the root cause of the problem: the parameter value cannot be found in the list after the refresh if it includes consecutive spaces. For example "Red fish" (one space) would work fine but "Blue fish" (with 5 spaces between the words) would not.

I don't have control over the data entry and I'd rather not use the SQL in the Data Source to try to "fix" it as it loads

KeshiaRose commented 5 years ago

Hi @JohnDelahunt, I've made some new updates to the extension and fixed a reloading issue. Could you please re-configure the extension and see if you are still seeing this error? If that doesn't work also try turning off the new "Update list of values on parameter change." feature which is on by default (as it matches original functionality). Let me know if this works for you, if not I'll re-open and investigate.

Take care, Keshia

KeshiaRose commented 5 years ago

Had some issues with the new updates so I rolled them back until we can confirm everything is good. But here is an alpha with the updates. Please do not use the alpha in production as it can change or be removed any time but let me know how it works for you, if it solves your issue and if you come across any other bugs!

JohnDelahunt commented 5 years ago

@KeshiaRose The problem with items containing multiple spaces has been resolved. Thank you.

KeshiaRose commented 5 years ago

Glad to hear it!

I released the fix and updates as a version 2.0.0. You can now upgrade to get the new features: https://extensiongallery.tableau.com/products/27

Take care, Keshia