KQL Query for selecting data from different table based on selection in ADX UI dashboard

Hi @Wilko van de Velde

Thank you for your reply.

From user perspective he might now know table name details.

I am looking for based on location selection from parameter, the data should come from equivalent tables accordingly.

I don't want to select table name in UI only location which is a column value of the table.

You can use a query for the values of the parameter. So that a user can select a value from the parameter list. So I change the parameter:

Than, I edited the query to query all tables:

.show database [PolicyTest] cslschema
| project TableName
| where TableName has ""
| extend Label = substring(TableName,2,3)

I added a label column for a user friendly text. Based on the information given, I cannot fill in the where operator and the exact logic for the Label. But it should result in something like this:

Last step is to change the value and label column to the columns produced by your query:

Now you can use the parameter in the query for your dashboard

Kind regards,

Wilko