I have a table with a field that contains a list of products, separated by comma (it’s a calculated field, so I can separate them by whatever if needed per the provided solution). On this table I have a number of navigation actions, one of which takes this field of comma separated products and send the user to another tab for a deep dive and puts that field in a parameter. It’s a multi value string parameter, and the control for it is set to comma separated. When the navigation action moves to the new tab and populates the control/parameter, the visuals all say “No Data”. If I open up the control dropdown, click to the end of the text that was inserted and hit “enter”, everything populates just fine. Seems a little broken to require the user to perform the extra step of hitting enter for the parameter/control to register. I’ve tried changing the calculated field to be pipe delimited and same for the control, same behavior. Is this just a configuration issue or a bug?
Hi @Ryan_Sawers -
Did you resolve your issue? If not, could you please provide the screenshot or example of how the parameter is set up so we can help? Thanks!
Yes this is still an issue - attached are screenshots showing the flow of the issue.
Here we have a view of ASINs, but one row has been associated with other ASINs that need to be looked at in a separate menu, so we provide and menu navigation action.
We can now see the data populated. So the comma separation works, the navigation works, the parameter and control appear to be correctly set up. The only issue seems to be that it doesn’t initially register until I hit enter. Let me know if you need any other information to help diagnose.
Thank you for sending over those visuals, that was really helpful!
Is there ever a scenario where that control filter that is affected by your navigation action has more than one option, and what type control is it? Is the control a drop down, text field, or a list?
If it never has more than one options what happens if you remove the control and just set the parameter to one of your comma separated values instead of using the navigation action from the first sheet?
In this scenario, the navigation action will only have more than one value, as that tab is dedicated to multi-ASIN analysis. The parameter is type string, multiple values. Control is Text field - multiline, separated by commas.
So I hope I’m following your suggestion correctly - I’m leaving the action unchanged and I’m just removing the control from the Multi ASIN Investigation tab, but the parameter is still there unchanged and filters pointed to the parameter. Using the action item in this scenario gives me “No Data” on all visuals.
After testing this on my side I believe that you do have to click through on the filter. Can you double check that the Parameter that for that control has the “Show blank by default” option unchecked and see if that makes a difference?
Also, is there a possibility that you could try changing this to a Dropdown multiselect and connecting it to the target field in your dataset?
The parameter was already unchecked for “Show blank by default”. I just tried with it checked as well and same issue.
I’m not sure changing to multiselect dropdown would help in this situation as we are trying to give a string to the control to select multiple values. I tried it out and it will put the entire comma delimited string in the search bar, which will yield zero results as there are no matching values. If I try this with a single value, it does work.
Thanks, @Ryan_Sawers. We have replicated this issue and identified it as a bug. @imaitri will be in touch with you (via your ticket) regarding next steps.
