Creating a Drill Through in ADX Dashboard From a Table

Hochgurtel, Brian D 0

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!

Brian

ShaikMaheer-MSFT 38,401 Reputation points Microsoft Employee

2023-02-27T10:20:27.9433333+00:00
Hi Hochgurtel, Brian D,

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.
Hochgurtel, Brian D 0 Reputation points

2023-02-27T17:30:32.9533333+00:00

Thanks for the reply! I will look at this and let you know if I have any questions.
Hochgurtel, Brian D 0 Reputation points

2023-02-28T16:20:52.12+00:00

@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?
ShaikMaheer-MSFT 38,401 Reputation points Microsoft Employee

2023-03-01T16:57:04.7333333+00:00

When you grab that link manually and open in new tab, is that working?
Hochgurtel, Brian D 0 Reputation points

2023-03-02T15:56:58.7766667+00:00

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.

Share via

Creating a Drill Through in ADX Dashboard From a Table