In a Data Model, I want to use one column as the description for another
I have a direct SQL data model. There is a URL(dashboardpageurl) column and a description (dashboardpage) of that URL in another column as shown:
I want to use the description column in place of the URL string so when I am in the Discover, I see the description as the clickable link not the URL link icon. Here is a Discover view showing the the URL column but no label is shown:
In SSAS and PBI, it is possible to make another column to be the description for another column. Can this be done in a Pyramid Data model?
I was able to do this in a tabulate, by leveraging the "hyperlink" function, but I still would like to make this work in the hierarchy.
I found an PQL function of the same name "HyperLink" I tried to use it in a calculated column but it did not work:
5 replies
-
Hyperlinking text in this context isn’t a fully feasible solution. The column can contain either a label or a URL—but not both. The engine can’t automatically merge two separate columns to create a clickable display label with an underlying link. That said, if your URL follows a consistent pattern, you can use the "Actions" mechanism instead. While it requires users to right-click and select the action from the menu, it’s a quick and effective workaround. See this link for an example.
-
a bigger question to pose: if the item showed up a hyperlinked text, how would the user easily diffreentiate between clicking on the item to load the new URL vs clicking on the item to drill down/cross highlight etc? It muddies the user experience for the end users.
-
Although not a 100% solution, you could consider to create a tooltip action to a discover or an illustrate inside a present.
The tooltip action can pass the cell context to the tooltip item ( value from rows for example ) and display the description column value or any PQL expiration.
The tooltip will be shown when hovering over the data cell.