Users unable to seer filter selections as we have used %prefix to hide the field from users - Solution needed
Hi Team,
We have hidden one field since users should not be able see this field in the front end. This field also part of drill down dimension. But when user reaches last level in drill down (this mentioned field is last in that drill down) user unable to see what he has selected meaning for instance lets take one example : Region >> Country >> City . City field has been hidden using hide prefix. We have created drill down with these dimensions and using in a bar chart. In this case when user reached city level drill down he is unable to see this values in current selections . This is misleading for the user. Is there anyway we show display these values in current selections. Hope this is clear. Please suggest a solution.
You may show the selected values within a textbox with functions like getfieldselections(FIELD) or getcurrentselections() or a concat(distinct FIELD, ',') but IMO it's quite adverse to hide a normal field with the hide prefix feature. Therefore I suggest to change this - maybe by replacing this field with a specially adjusted duplicate of this field.
