Variables
A variable is a placeholder for a value. You can use variables in queries so when you change the value, your queries will be re-ran and the chart or table updated.
- Variables map keys to values.
- Setting Variables
- These variables can be empty or set to defaults by the author when a dashboard is loaded.
- User interaction with User Forms or Chart/Grids can set variables
- User Forms have buttons, text inputs, numeric inputs etc. mapped to author specified keys.
- Chart automatically populate specially named keys (ts/name/seriesName) when clicked.
- Tables populate keys named tbl.YYY where YYY is mapped to each column name and the value is the selected rows column value.
- Once a variable is set. Any SQL query containing that variable is sent and the view automatically updated.
Notice in the picture below, the author has added a Debug component. This component shows the value of all keys/values. On the left is a form where the user has chosen EUR/JPY, this causes the variable ccy to map to the value EUR/JPY.
Page Address Importance
The web page address contains the current key/values at all times. You will notice as you set variables either by interacting with forms, charts or tables that the address bar gets updated to contain these vaiables like so:
http://pulseui.net/dash/5/PnL?ccy=EUR%2FJPY&days=2This has a number of benefits:
- You can bookmark and share a page by emailing the URL.
- When an author saves a dashboard, the current values in the URL are used as defaults when a dashboard is first loaded for other users.
Variable Formatters
Syntax: {{variable_name:format}}
The formatting of the variable normally depends on the data source, but in some situations you might want to override the default formatting. If for example you are trying to generate a query that involves nested quotations.