Parameters are user-generated values that are not tied to a data source. These values can be used as inputs within calculated fields, reference lines, and/or filters. What makes this feature powerful is that after the author sets the limits of the values available in the parameter, the author and their users can change the value on-the-fly by using a parameter control or dashboard actions (discussed in Chapter 14).
This chapter shows you how to make a parameter, how to use dynamic parameters, and presents some popular use cases.
How to Make a Parameter
You can create a parameter by right-clicking any blank space on the Data pane or by left-clicking the down-arrow in the top-right corner of the Data pane and choosing Create Parameter.
Although parameters don’t show up in the underlying data, it helps to think of each parameter as a new column in a data source, with its single value appearing on every row. Since each parameter is a new column, you must assign it one of the six data types covered in Chapter 3. Figure 12-1 shows the Create Parameter dialog with the data type options.
Figure 12-1. Create Parameter dialog
After setting the data type of the parameter, I recommend focusing on the “Allowable values” section of the dialog, where you can limit which values can be selected. There are three radio buttons to choose from:
All (the default)
Allows the ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
