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.
What I meant is that pivot tables can be customized in a lot of ways that result in various columns and rows, but this is constructed in the browser, and its starting point is the underlying query's returned rows and columns. So only those are shown as available columns.
Could you share, if possible, the columns that the simple "Table view" returns? Is it those four columns?
Hi Marcos,
Thank you for your willingness to help me. I'm sharing the columns returned by the simple table view. In images 1 to 3, you can see the columns. The last image shows the columns available for selecting the destination URL, and I highlight the column I need to have available in the pivot table view, but I understand it won't be available. These are the same columns contained in the pivot table view.
