What is a parameter?
- A parameter is a workbook variable such as number, date, or string that can replace a contant value in a calculation, filter or reference line
Use Case
-Top N
- Moving Average
- Choose date range
-Sort Stacked Bar - Filter unrelated data sources
1.)Top N (2 Ways)
- With this method, a slider can be created to define the top N to be shown on canvas
Second Method
Then we link the created parameter with the variable