{
    "version": "https:\/\/jsonfeed.org\/version\/1",
    "title": "LEFT JOIN: blog on analytics, visualisation & data science, posts tagged: parameter",
    "home_page_url": "https:\/\/en.leftjoin.ru\/tags\/parameter\/",
    "feed_url": "https:\/\/en.leftjoin.ru\/tags\/parameter\/json\/",
    "icon": "https:\/\/en.leftjoin.ru\/user\/userpic@2x.jpg",
    "author": {
        "name": "Nikolay Valiotti",
        "url": "https:\/\/en.leftjoin.ru\/",
        "avatar": "https:\/\/en.leftjoin.ru\/user\/userpic@2x.jpg"
    },
    "items": [
        {
            "id": "16",
            "url": "https:\/\/en.leftjoin.ru\/all\/using-redash-parameters\/",
            "title": "Using parameters in Redash",
            "content_html": "<p>The most convenient and useful thing in Redash is parameters. Parameters can be both in a report and in dashboards.<br \/>\nParameter – is an element of the interface, controlled by a user producing a report.<\/p>\n<p>Parameter in a report can be of the following types:<\/p>\n<div class=\"e2-text-picture\">\n<div class=\"fotorama\" data-width=\"541\" data-ratio=\"1.9049295774648\">\n<img src=\"https:\/\/en.leftjoin.ru\/pictures\/redash-parameter@2x.png\" width=\"541\" height=\"284\" alt=\"\" \/>\n<img src=\"https:\/\/en.leftjoin.ru\/pictures\/redash-parameter-v2@2x.png\" width=\"540\" height=\"267\" alt=\"\" \/>\n<\/div>\n<\/div>\n<p>Each type explained separately:<\/p>\n<ul>\n<li><i>Text<\/i> – text input field, can be used in constructions of LIKE type, such parameter <a href=\"https:\/\/redash.io\/help\/user-guide\/querying\/query-parameters#FAQ\">can’t be applied in public dashboards<\/a><\/li>\n<li><i>Number<\/i> – number, entered by a user<\/li>\n<li><i>Dropdown list<\/i> – list of values, from which a user can select just one or several values (not long ago, an option of multi-entry of parameters in a dropdown list appeared)<\/li>\n<li><i>Query dropdown list<\/i> – similarly to the previous one, however the values will be taken from the existing query results<\/li>\n<li><i>Date<\/i> \/ <i>Date and Time<\/i> \/ <i>Date and Time (with seconds)<\/i> – fields of date entry<\/li>\n<li><i>Date Range<\/i> \/ <i>Date and Time Range<\/i> \/ <i>Date and Time Range (with seconds)<\/i> –  fields of date ranges entry.<br \/>\nIt’s convenient to use for the following construction<\/li>\n<\/ul>\n<pre class=\"e2-text-code\"><code>between '{{parameter.start}}' and '{{parameter.end}}'<\/code><\/pre><p>In case of dashboard, a situation might arise, when a parameter is named the same way in several queries, then it will become common for all the dashboard, it’s handy.<\/p>\n<p>One of not obvious, but rather useful solutions: how to make a parameter <b>disabled<\/b>?<br \/>\nLet’s assume, that parameter of “dropdown list” type is named <i>parameter<\/i> and we want to set it for a column <i>geo<\/i> of a table, then the code of the query will look approximately like that:<\/p>\n<pre class=\"e2-text-code\"><code>WHERE\r\n    ('{{parameter}}' = 'Disabled' or geo = '{{parameter}}')<\/code><\/pre><p>At that, surely, ‘Disabled’ should be added to the values of the dropdown list.<\/p>\n",
            "date_published": "2020-01-28T14:22:01+03:00",
            "date_modified": "2020-05-13T14:17:42+03:00",
            "image": "https:\/\/en.leftjoin.ru\/pictures\/redash-parameter@2x.png",
            "_date_published_rfc2822": "Tue, 28 Jan 2020 14:22:01 +0300",
            "_rss_guid_is_permalink": "false",
            "_rss_guid": "16",
            "_e2_data": {
                "is_favourite": false,
                "links_required": [
                    "system\/library\/fotorama\/fotorama.css",
                    "system\/library\/fotorama\/fotorama.js",
                    "system\/library\/highlight\/highlight.js",
                    "system\/library\/highlight\/highlight.css",
                    "system\/library\/highlight\/highlight.js",
                    "system\/library\/highlight\/highlight.css"
                ],
                "og_images": [
                    "https:\/\/en.leftjoin.ru\/pictures\/redash-parameter@2x.png",
                    "https:\/\/en.leftjoin.ru\/pictures\/redash-parameter-v2@2x.png"
                ]
            }
        }
    ],
    "_e2_version": 3386,
    "_e2_ua_string": "E2 (v3386; Aegea)"
}