LoslegenKostenlos loslegen

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?

Diese Übung ist Teil des Kurses

Databricks Concepts

Kurs anzeigen

Interaktive Übung

In dieser interaktiven Übung kannst du die Theorie in die Praxis umsetzen.

Übung starten