Aan de slagGa gratis aan de slag

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?

Deze oefening maakt deel uit van de cursus

Databricks Concepts

Cursus bekijken

Praktische interactieve oefening

Zet theorie om in actie met een van onze interactieve oefeningen.

Begin met trainen