I need your help figuring out what conditions or properties fields in a question must have to appear as available columns. I have a query in a dashboard, but only four
available columns appear when I have nine columns. I've already checked the metadata settings in the table containing the fields that appear as available fields and compared them with the fields that don't appear in the list, and I don't find any differences in their settings.
It's showing the underlying columns of the question as possible options (the columns you would see if you were using a normal Table visualization), but it does not support using columns that only exist in the pivot view. I assume those are the missing ones, correct?
Hi Marcos,
Thanks for responding. You're right that the URL link feature isn't enabled for all pivot table columns... apparently the problem is caused by the change in formatting between this view and a normal table view. But I'm confused when you say "only exist in the pivot view," since in my table, all the columns exist in their respective source tables. I don't have any custom columns.