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

Conditional Formatting is here

We have launched a major new feature that adds Excel-style conditional formatting to Table, Pivot table and Number charts.

You can easily add one or more rules that apply formatting or add icons based on rules. The rules provide advanced conditions such as value, percents, or percentiles for numbers.

The formatting provides few useful presets, custom font styling and colors, and even allows applying a custom CSS string, so you have virtually limitless options for visually representing the conditions.

For more details about the functionality see the docs page here.

conditional-format-1.png

conditional-format-table.png

Use filter values in report title or description

You can now use the selected filter value(s) in a report title, description or custom "No data" message.

Having the report title set as

Airports in {selected_countries} ({result_rows})

Will render the report title like this when "Australia" and "New Zealand" are selected:

airports-in-australia-new-zealand.png

See the full docs here.