[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-14 UTC."],[],[],null,["# 2.x Release Notes\n\nLooker 2.4 2014-07-14\n---------------------\n\n### LookML / Projects\n\n- New field parameter `format:` for [printf-style formatting](/looker/docs/2512/reference/param-field-format)\n\n### Explore\n\n- Totals working in all dialects, implemented as a separate SQL query\n\n### Data Visualization\n\n- New element parameter `show_applied_filters: false` to turn off dynamic filters in title of a dashboard element\n- New dashboard parameter `refresh: N minutes` to refresh data every N minutes if the page is open\n\n### Enterprise, Platform, and Security\n\n- LDAP authentication\n- Two-factor authentication\n\n### Bug Fixes and Tweaks\n\n- Add/delete projects moved to admin panel\n\nLooker 2.2 2014-06-09\n---------------------\n\n### Data Visualization\n\n- [Custom map visualizations](/looker/docs/2512/visualization-types#maps)\n- [Dimensional scatter plot](/looker/docs/2512/scatter-options)\n- Automatic x_axis_scale detection\n- x_padding_left and x_padding_right option for charts\n- Specify colors, series_colors, series_labels, reference lines, and more in looker_type charts\n- Plot geo coordinates (lat/long) on world map\n\n### LookML / Projects\n\n- Redesigned Projects experience\n- LookML project search with regular expressions \\& find and replace\n- JGit bundled with Looker (replaces server-based git)\n- [Liquid templating](/looker/docs/2512/liquid-variable-reference) (replaces ERB)\n- [More flexible join syntax](/looker/docs/2512/reference/param-explore-join)\n- Top nav menus update upon LookML file save (instead of after page reload)\n- Declare a base_view as hidden: true\n- [Table Calculations](/looker/docs/2512/table-calculations): type: running_total\n- Line-by-line git diffs in LookML editor (yellow for modified, green for added, red for deleted)\n\n### Explore\n\n- Jump to LookML error link from Explore page\n- Improved and more flexible number filter syntax (e.g. \\\u003e, \\\u003c, != operators)\n- SQL Runner moved to Explore menu\n- SQL tab updates live as query is constructed in UI (with EXPLAIN)\n\n### Enterprise, Platform, and Security\n\n- Improved admin audit and Looker usage panels\n- Embeddable iframe code added to public URL box\n\n### Bug Fixes and Tweaks\n\n- Lots of looker_ (area, column, etc.) and reference line bug fixes. Thanks to the beta testers!\n- Improved login and auto logout flow\n- Convert \"yyyymmdd\" format to valid time field\n- Year filters now use date syntax (instead of integer)\n- Dozens of other bug fixes and tweaks!\n\nLooker 2.0 2014-04-28\n---------------------\n\n### Data Visualization (Beta)\n\n- Maps (US \\& World) chart types: [Coordinates Plot](/looker/docs/2512/visualization-types), [Choropleth](/looker/docs/2512/visualization-types)\n- New Cartesian chart types: [Single Record](/looker/docs/2512/visualization-types), [Donut](/looker/docs/2512/visualization-types), [Donut Multiples](/looker/docs/2512/visualization-types)\n- Updated Cartesian chart types: [looker_column](/looker/docs/2512/visualization-types), [looker_line](/looker/docs/2512/visualization-types), [looker_area](/looker/docs/2512/visualization-types), [looker_pie](/looker/docs/2512/visualization-types)\n- Reference Lines: static, median, mean, min, max, ranges, standard deviation, variance\n- Additional formatting parameters (interpolation, colors, hide_points, hide_legend)\n- Automatically detect and format date axes\n\n### LookML\n\n- [Developer vs. Production Mode SQL option in PDTs](/looker/docs/2512/dev-mode-prod-mode)\n- Field name validation before query run\n- Generate files as .model.lookml, .view.lookml, .dashboard.lookml\n- When on, user access filters block filter suggestions\n- select_filter aliased to suggest_filter in dashboard filters\n\n### Enterprise and Security\n\n- Auto user log out (with warning) unless trusted computer\n\n### SQL Dialects\n\n- Support for Teradata Aster 6.0\n- (Beta) Support for Oracle Database 11g\n\n### Bug Fixes and Tweaks\n\n- Persistent derived table fixes\n- Drilling into a dashboard chart keeps filters applied\n- Timezone conversion in Redshift\n- Warn when changing timezone that it affects all users\n- Show conditional filters in dashboard URL\n- Return 401 error as JSON API responses when authentication fails\n- Add link to SQL Runner from connections page\n- MS SQL Server suggest fix"]]
