I have a dataset with multiple countries listed in a filter. It makes no sense in our project for the end user to be able to select multiple countries so is there a way to restrict the user access such that they can only ever select one country at a time?
J - This is an interesting suggestion, how many countries are in your data set? At the moment you can only isolate on one country using Named Queries to focus each view (or all the views on a tab) on each country...but this requires one tab per country. One workaround would be to define a Text Choice Variable which has the values of all the country names, and then write Subset formula so that only data for each country are displayed based on the user selecetion in the Sidebar Variable radio button list of countries. If you post a scrambled sample of your file we can see if that is feasible.
Thanks, I am sending our file.
FYI, country is not the only field that we wanted exclusive, If you see in our file, we also want "metric" unique because it makes no sense accumulated different metrics.