Get startedGet started for free

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?

This exercise is part of the course

Databricks Concepts

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise