Creating a Drill Through in ADX Dashboard From a Table
I have a ADX dashboard that has three pages in it. The first page is at the customer level and lists several instruments and their data along with any errors the instrument maybe providing. The second page contains details on the instrument like health, recent errors and warnings. The third page has aggregated table. I know that ADX does allow for drills per this documentation: https://learn.microsoft.com/en-us/azure/data-explorer/dashboard-parameters#use-drillthroughs-as-dashboard-parameters
However those examples are from a graph or chart. I need to link to my errors and data pages within my dashboard from a table in the dashboard, and I can't find an example that shows how to do that.
Any suggestions? Thanks!
Thank you for posting query in Microsoft Q&A Platform.
Kindly check below implementation if that helps.
You can consider adding a table to the dashboard that lists the instruments and their data. In the table, add a column that contains a link to the detailed view of each instrument. When you click the link, it will take you to the detailed view of the instrument in the second page of your dashboard.
let table = datatable(instrument: string, data: int, link: string) [ "Instrument 1", 100, "dashboard://instrument1", "Instrument 2", 200, "dashboard://instrument2", "Instrument 3", 300, "dashboard://instrument3" ]; table | render table
In above example, the "link" column contains the URLs for each instrument's detailed view. When you click the link, it will take you to the corresponding dashboard page.
Hope this helps. Please let me know how it goes or if any further queries.
Thanks for the reply! I will look at this and let you know if I have any questions.
@ShaikMaheer-MSFT When I try to execute your example, I do not get a link to click on. It's just text. See screenshot below. I did bring your code into some real data and made the column a hyper link field and when I click on that it does not direct me to another dashboard even though I changed the link to include the dashboard name. Am I missing a step here?
When you grab that link manually and open in new tab, is that working?
I've tried to used dashboard://Tenant Summary in a number of different ways, and it doesn't appear to work. Can you provide some more detail on how this is supposed to work.
Sign in to comment