Column Styling

Column Styling

• A new Columns tab is now available when a widget is selected.
• Column styles can be added, providing a column id (the field from your SQL query) and an optional title. Specifying a title will use the provided value in place of the axis/legend/series title in a chart or table.
• Column styles can be reordered. This will cause the chart/table columns to appear in the same order.
  • note: this has no effect if you're using the view.columns in json, or using the pivot's "sort columns" feature. UX for both of these will be folded into the Columns sidebar before release.
• Data roles can be specified on columns. This will cause the column data to affect the chart in different ways (annotation, tooltip, etc.).
• Color can now be specified on columns that will render as data series in a chart (typically this is non-data role columns excluding the first one). This will affect the series color. Note that color support on columns is not "complete" Some charts don't support color customization at all, and others don't use the series array approach that the "core charts" use. A summary of the current state:
  • Supported: Area, Bar, Candlestick, Column, Combo, Histogram, Line, Scatter, Stepped Area
  • No Color Support: Annotation, Calendar, Gauge, Org, WordTree
  • Future Support: Geo, Pie, Sankey, Table, Timeline, TreeMap

Charts

• Added Annotation Chart to the list of available charts.
• Fixed an issue preventing the Word Tree from rendering.

Other Fixes

• When selecting a widget, if no tab is selected (or a non-widget tab is selected, such as Container or Dashboard), the first widget tab will be selected. If a widget tab is already selected (Chart, Columns, etc.), no change will be made.
• Fixed an issue where inserting a container before/after the selected one didn't properly register the container.
• Fixed an issue where moving a widget to the top/bottom boundary of the list would fail to register the new container.
• Fixed an issue with the width of the dashboard parameters control.

Fix Dashboard Linking

• Widget URL's referring to the current dashboard are now properly handled.
• Dashboard parameters passed on the URL are now properly handled.
• The sidebar can now be resized when no widget is selected.
• Fixed an issue where sidebar content would not scroll properly.

Deep Linking

Deep Linking

• The selected widget and container are now tracked in the URL. When opening a url that specifies a widget/container, it will be pre-selected and scrolled into view on the dashboard.

Dashboard Layout

• Selecting a widget will now scroll it into view if it's partially visible in the viewport.
• Containers and widgets now appear at their defined height even when no data is present or there is an error. This makes dashboard layout considerably more stable.

Administrative

• Integrates AngularUI's ui-router for URL->state mapping.

List More Dashboards

• Raise the limit on dashboards returned on the admin page from 1k to 2k.

Loading & Edit SQL Fix

• Fixes an issue where the Edit SQL button was non-functional if the widget was missing datasource.results.labels.
• Fixes an issue where the loading glyph would remain visible if no query was present.

UIGrid Improvements, Bower Integration

Fixes/Improvements

• UI-Grid (in dashboard admin) now uses case-insensitive matching.
• Fixed an issue with Deleting a dashboard from the dashboard page.

Administrative

• Use bower instead of npm to deal with client-side (javascript) deps.
• Update to latest release of ui-grid.

New UX & Sidebar

Sidebar & New UX

• Removed the right-hand sidebar, and organized the left-hand sidebar into tabs. See go/perfkit-sidebar-design for details.
• Restyled header, toolbars and footers to material design-ish colors and styling.
• Moved toolbars inline with sidebar tabs. Toolbar and sidebar panel selection is all controlled from the left-hand tabs.

Dashboard Customization

• Added "header_text" and "footer_text" to container configuration. Future releases will allow additional formatting.
• Added legend details (alignment and maxLines) in addition to position in the Chart Config.
• Added Chart Area to the Chart Config section.

Performance

• Updated client dependencies, notably:
  • Angular 1.4.1
  • CodeMirror 5.3.0
• Enabled optimizations in jscompiler, improving performance and decreasing script download size.
• Enabled ES6->ES5 transpiling, and started integrating ES6 features into code.

URL Parameters and Fixes

• Widget URL's can now contain parameters.
• When a URL would change the parameters but not the root URL, the affected widgets correctly refresh
• Fixed miscellaneous resize issues in the CodeMirror directive.

Dashboard Parameters and Resizing

Resizing

• The sidebars and footers can now be resized. You'll see thicker grey bars at the extents of the panels (left, right and footer), just drag-drop to resize.

Parameterized Dashboards (http://goo.gl/zQJqBw)

• The dashboard settings now contains a name/value list for Parameters. You can add any string for a name, and provide a default value.
• Queries (builder and custom SQL), as well as widget and dashboard titles, now support injecting parameters using the %%NAME%% syntax.
• The Querystring (url parameters) can be used to override parameter values. Adding &NAME=custom_name to a URL will overwrite the default value for the NAME parameter.

Widget URL

• Each widget now supports a URL property. If provided, the widget will have a blue link icon in the top right (next to the refresh button) that will open the provided url.

Edit/View SQL Changes

• The header toolbar no longer displays an 'Edit SQL' button. Instead, if you change any text in 'View SQL' mode, the widget will automatically go into custom SQL mode. The "Use Builder" button is still available to revert back to UI generation.
• Cleaned up general wonkiness in SQL and data availability when switching between modes.
• Removed the Refresh and Customize Builder buttons from the left sidebar.

Layout Changes

• The footer no longer appears by default. To show the footer, choose "View SQL", "Edit SQL", "Edit JSON" or "Show n Warnings" (log) from the main toolbar.
• Swapped the colors of Widget->Insert and Widget-Refresh on the top toolbar.
• Pressing ESC will de-focus the current input/button control, and pressing it again (or with nothing selected) will de-select the currently visible widget. If the footer is showing either SQL or JSON, it will be hidden. If the footer is showing LOG, it will remain.

PerfKit v21 - Table Decorators

Table Wildcard Support

• A new SELECT box appears in the Datasource configuration section. This allows the user to switch between two styles of table. OneTable (the default) assumes all data exists in a single table. PerDay, on the other hand, utilizes the Table Wildcard functionality of BigQuery (see link below) to store data in a table-per-day.
  • If the SELECT box is left at "OneTable", the SQL and query will behave as usual.
  • If the SELECT box is left at "PerDay", the SQL FROM clause will use the Table Wildcard function to query for table names within the provided date range. Some notes on this behavior:
    • If no End Date is provided, CURRENT_TIMESTAMP will be used as the default. (this prevents unbounded future data queries, which aren't being used anyways)
    • If no Start Date is provided, an error is thrown.

Infrastructure Improvements

• Various tweaks to javascript to make karma tests 'just run'. A guide with be forthcoming.

Administration Improvements

• The right-hand gear icon now contains a 'Edit Config' menu option (only available to admins). This allows authorized users to view and modify the default BQ project/dataset/table, analytics key and cache duration. This takes the place of data_source_config.json, and makes deploying to various environment significantly simpler. Additional options (and user settings) will be added here in the future.

Miscellaneous Fixes

• Removed MEAN as a Measure option in QueryBuilder. AVG or 50% should be used to determine the MEAN or MEDIAN respectively.