IniziaInizia gratis

Using parameters in queries

One of the queries you have created analyzes your sales from various book distributors. You have created a variety of visualizations from this query and are looking to share the results of this query in an interactive dashboard. Certain individuals will want to change the criteria for which distributors the query looks at. Thus, you decide to create two parameters and put them in your query:

  • companyName : a drop-down selector that allows the user to select a single distributor to analyze
  • transactionCount : a numerical value that denotes the number of books sold in each individual transaction

Which of the below queries will give us the result that we want while also creating the parameter widgets in our dashboard?

Questo esercizio fa parte del corso

Databricks Concepts

Visualizza il corso

Esercizio pratico interattivo

Passa dalla teoria alla pratica con uno dei nostri esercizi interattivi

Inizia esercizio