![]() ![]() Maybe you have a dashboard containing questions that track how different products in your inventory have sold, and a dashboard filter that lets people input the product they want to check in on. For example, you can set a custom destination by using values from the card’s results to construct a URL that directs people to another dashboard or external site with that ID as part of the URL. You can also insert parameters into a URL to dictate what happens when people click on a chart in a dashboard. When you enter a value into a dashboard filter, you’ll notice that the URL changes to include that value. A dashboard with a filter applied on the State column. Then when people enter the value they want (like North Carolina, shown in figure 2), they’ll see those cards change accordingly. For example, you can create a dashboard filter that lets people input a State value and link that that filter to the State column in the questions or cards on your dashboard. Dashboard filtersĭashboard filters let you set parameters that get applied to a dashboard. Creating a SQL template that adds a filter widget to a query. For example, if you set a parameter as in double curly brackets, we’ve created a parameter that adds a filter widget to this question, letting people input the state they want without needing to change the text of the query itself, like in figure 1: Fig. Not all variables are parameters, though - you may also have variables that are set within your program or query and can’t be modified by anyone on the other side.Īn argument refers to the value itself that gets passed along when your program or query runs. A parameter is a type of variable it’s just one where some specific input value gets passed along to the program or query being run. You may see “parameter” used interchangeably with “variable” or “argument,” so it’s worth pointing out some distinctions here. The parameter passes that value through to the query being run, and the results of that query will depend on whatever value that person entered. Setting a parameter lets end users input a value (like in a dashboard or report) to change what data that query returns, typically filtering by a measure or dimension. A parameter is a special type of variable that specifies an input to a query.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |