"Display as" LINK in drill-down view of pivot table not working

Get Help
1

Hi,

I’m working with a Pivot Table that allows me to drill down into various KPIs for more detailed information. This opens a more detailed view for the selected time period, as shown in Image One for reference.
PIVOT in Dashboard:

Screenshot 2024-11-05 at 14.32.48
Screenshot 2024-11-05 at 14.32.481460×648 42.8 KB

Drill Down Pivot when clicking on 38:
Screenshot 2024-11-05 at 14.38.28
Screenshot 2024-11-05 at 14.38.281344×640 66.3 KB

So when I click on the "38," it takes me to the underlying Records Table, where I want the "DEAL_ID" and "COMPANY_ID" columns to appear as clickable links. I’ve set the "Display as" option from "Automatic" to "Link" in the underlying Records Table, and it works there as expected(see Image 3:

Screenshot 2024-11-05 at 14.42.38
Screenshot 2024-11-05 at 14.42.381294×416 44.4 KB
)
. However, when I drill down from the pivot table, these columns don’t display as links.

Is there a way to ensure that these columns display as links in the drill-down view from the pivot table? I even tried to change it in the Pivot Drill down and save the pivot and then recreate it with all the previous modifications in the "Explore Results" but it changed back to not showing links after saving and recreating...

Thanks!

2

Help would be highly appreciated!!

3

I'm using v49.13 and I'm able to drill down and get the links in the destination. I have defined the formatting at the field level though (settings->admin->table metadata)

4

We are using v51.2 and it does not seem to be working. Also table metadata is only applied to the Question builder right? When writing the queries manually in SQL it does not seem to apply the formatting...