Underflow and Overflow bins for Historgram chart

We launched recently a few improvements for the Histogram chart:

  • you can now define minimum and maximum values for the histogram, which would place any values outside of this range into special underflow and/or overflow bins. You can define a different color to be used for those bins, so any outliers would either stand out (when unexpected) or be diminished (when the outliers are not interesting)
  • fixed upper boundary of the last bin to correctly display the value corresponding to the bin "width" (previously the maximum value present would be displayed on the axis, which could be misleading).

Screenshot 2020-12-23 at 14.11.33.png

Fix query history for analysts without "admin" role

We just deployed a fix for a bug where for some users "Insufficient permissions" would be displayed when viewing their query history in the report editor.

Show zoom controls for Map charts

A minor improvement adds the option to show zoom controls on the map chart to make it easier/clearer to zoom for some use cases or devices.

show-zoom-controls-news.png

New R libraries supported: pwr and sigr

Our R environment now includes 2 new packages:

  • pwr (1.3-0): Basic Functions for Power Analysis
  • sigr (1.1.3): Succinct and Correct Statistical Summaries for Reports

See docs for an overview of all supported libraries and their versions.

Gauge chart

We have added a new chart type to our charts stable: Gauge chart

Gauge chart shows either a 240° or 140° circle arc, colored ranges, and a "current" value pointer which highlights the color of the matching range.

The definition of the ranges can be fixed or can come from the SQL, so the ranges can, for instance, be based on goals that change over time.

You can find out more details in the docs.

gauge-chart-news.png

Drill-down now available on Pie chart

The ability to drill-down is now also available for the Pie chart reports.

pie-chart-drilldown.png

Lots of improvement for the report editor

We have launched a set of improvements for the analyst experience in the report editor. These include:

  1. the Almanach sidebar can now be collapsed so you have more space for editing and chart configuration on smaller screens when the almanac is not needed

collapsed-sidebar.png

  1. Query history, which includes all the queries you executed in the past in the report editor for the currently selected datasource. You can use a full-text search to filter the results.

query-history.png

You can also easily diff the query to the current one or take over the query from the history:

query-diff.png

  1. Report history - when editing an existing report, the Report history displays all historical changes made to the report, together with who and when made the change and high-level overview of the changes. You can easily restore a past version or see a low-level diff of that change or diff to the current report configuration.

report-history-item.png

Use current date in dashboard schedule subject or body

A small improvement adds the ability to include current date in dashboard schedule emails - simply use {date} anywhere in the subject or body field and it will be replaced with the current date, formatted according to your organization preferences.

date-in-schedule.png

date-in-schedule-email.png

Sparkline mode for Line and Bar charts

A new setting for Bar and Line charts allows configuring the chart with minimal visual clutter and margins displayed, suitable for displaying as small charts that give further context to another metric or report.

sparklines.png

Smart color picker

We have improved the color picker used for assigning custom colors in charts or picking a color for conditional formatting.

The main improvements are:

  • a quick visual way to pick a color
  • smart automatic list of previously/frequently used colors - the color picker has a list of colors used on any of your reports, so reusing a common set of custom colors is fast and easy

color-picker.png