Release Notes

We continue to add new features, check out what we've added

January 2023

Data Source Dependencies

When tables and columns (objects and properties) are removed from a data source the downstream effects are made available in the model and collection sections. For example, if a column is removed from the data source and it was used in the model (joining data, transforming data, or Row-level security segmentation) or in the collection on a filter or tile, admins will be alerting and given the ability to swap columns to remediate the issues.

Removing Tables and Deleting Views

The issue inhibiting the removal of tables and deletion of views has been fixed. Additionally, you may run a dependency check to find any downstream impacts in transformations or collections.

Collection and Tile Configuration Updates

Pivot Tables - Column Headers when 1 Value

The system will hide the value column headers when there is only 1 value field so that there is less redundancy in the visualization.

Table Tiles - Display Duplicate Row

There is a new configuration option to show or hide duplicate rows on table tiles. By default, duplicates are shown.

Date Filter Presets

New Date Filter presets are available for admins to activate for the end-users. The new options are

  • Daily - Yesterday, Today, Tomorrow

  • Weekly - This Week (Mon - Sun), Last Week (Mon - Sun), This Week (Sun - Sat), Last Week (Sun - Sat)

December 2022

Tile Updates

Table Tile - Column Filtering

Allow end-users to search and filter columns within a table tile. The filter options are specific to the column's data type for better user experience.

KPI Sparkline Tile

Create a KPI tile that includes a trendline or sparkline chart. This creates more visual interest in your dashboards and tiles.

Funnel Diagram - Custom Sorting

Sort funnel stages at the tile level to ensure that the funnel chart shows the proper event paths for the data displayed.

Tile Action Updates

Additive Filtering on Open New Tile Actions - Table Tiles

When creating an Open New Tile Action select how the action fields will be used in filtering the child tile using additive or exclusive filter logic. Additive Filter Logic will apply all configured filter values to the child tile when the end-user selects any active field on the row. Exclusive Filter Logic will apply only the selected value as a filter on the child tile when the end-user selects the field in the table.

November 2022

Tile Updates

CSS Classes on Dimensions and Categories

On embedded collections target dimensions and categories to control styling. For example, apply a specific color to categories in a bar chart that relate to other configuration data in your platform.

Scatter and Bubble Plot Reference Lines

Add reference lines to your charts to help with trend analysis.

Box Plot - New Tile

Our Box Plot chart is now generally available.

Tables - Conditional Formatting

Apply styling to table tiles based on the conditions applied. This is available on table tiles, on the display tab.

Download/Export Progress

When downloading data or visual exports users will see a progress indicator to give insight into the download progress. This will help for those especially large reports!

Null Styling

When presenting data that is represented as Null or empty in the database, Null styling allows you to select the text that displays if there is a null value. This is available on the field configuration panel on tiles.

Group By Date (Past/Future)

You can now group tiles visually into Past/Future. Learn more here.

General Updates

Text Filter Styling and Functionality

Improvements to the dashboard collection text filtering UX and query performance. If you have a text filter live, the enhancements will automatically be applied.

Debugging Support

Data not showing as expected in your tiles? The debug feature breaks down the data query step by step giving you a view into the data at each step. This will help identify where the data deviates from your expected output.

Designate Primary Keys

This feature allows you to designate a field as a primary on a data source table that does not contain a primary key. This enables transformations to be built on tables that don't have an established primary key. To add a primary key to a table go to the data source, sync settings section, then open the column panel. Once this is set, the model will all for calculated columns and aggregated measures to be set on these tables.

October 2022

Performance Updates

Updates to the client-side query process to increase query capacity and speed. Dashboard Collections load faster

Refresh Interval - Embedded Collections

Set the refresh interval for embedded dashboards that will automatically refresh the data shown.

September 2022

Table Tile - Comparisons

Add comparison values to table tiles without any data transformation! You can add a comparison value as an absolute or percent change.

Scatter Plots and Bubble Charts

Help your end-users identify patterns in their pattern with Scatter Plots and Bubble Charts. Scatter Plots may also be grouped to show multiple categories through colors and shapes.

Live Currency Conversion

With Verb's newest currency conversion feature your users can set their own exchange rates and view their internal currencies in a shared currency. The flexibility of this feature is unique and does not require stored exchange rates, only an ISO code to designate the stored currency type per value.

Learn more in the Currency Conversion section.

Tile Actions

We've added the ability to create cross filters on table tiles. See the Tile Actions Section to learn more about the Filter Data Tile Action

Dashboard Filtering

Multiple Fields per Filter

Display a single filter type that combines multiple fields. For example, your end-users may want to filter on a person's name however names come from different fields when their are customer accounts and admin accounts. Combine these filters into a single text filter and label it "Name". This provides a better user experience for the end-user and simplifies the number of filters they have to manage.

To add a second field to an existing filter open the dashboard filter and select the "Add Field" button in the left panel.

Filter Application - Hidden Filters

Hidden Filters are now applied first then visible filters. This helps limit incorrect data from showing in visible filter lists.

PDF Download

You can now include the filter set in the PDF download to give users more information in their printouts.

Tile Updates

Tile Title Alignment

Change the position of Tile Titles from Left Aligned to Center Aligned. This is set at the tile level in the Tile Title Section

KPI Updates

KPI Icons - Add an icon to Single KPI Tiles to create more visual interest and your draw users' attention. You can select an icon from FontAwesome or link to a custom icon of your own.

KPI Alignment - KPI values can now be left, center, or right aligned to give more flexibility.

KPI Title Position - KPI Tile Titles and Icons can be placed in the Top or Bottom of the Tile to create more visual interest and draw attention where needed.

KPI Spacing - We've updated the KPI spacing rules to ensure the layout works in more scenarios

August 2022

Enable your end-users to export an image of their entire dashboard. Make this option available on the dashboard collection filter tab with the Print to PDF toggle.

Date Filters - Range Limits

On your date filters, you can now configure the minimum and maximum date ranges available for your end-users. To configure this option, open the date filter in your dashboard collection.

iFrame Active Authentication

You can now use the active authentication features with our iFrame embed. New docs will be released soon!

New Aggregation Types

We've added the ability to count by boolean types and null values.

July 2022

New Chart/Tile Types

Text Tile - Create tiles with a static message for your users. You can format your text with mark-down styling.

Section Title Tile - Create sections within a dashboard collection with the Section Title Tile. This tile will always be full width on the dashboard. In the future, we may add more granular control.

Data Source Management

The data source management section was completely revamped to show more information and better error remediation functionality. See the Data Synchronization docs for more details.

Flat File Mapping

When importing flat files you may add new versions to existing files. When adding a new version you can now map columns across versions and add new sheets and columns to the file.

June 2022

New Chart/Tile Types

Maps - Visualize your data geographically!

Funnels - Event data can be displayed as a funnel chart to show conversions through a funnel.

Venn Diagrams - Compare data and overlapping information with Venn Diagrams.

New Tile Actions

Control Filters (Cross Filtering)

Use chart data to filter the rest of your dashboard. For example, an end-user can select a date range on a time series chart and the rest of the tiles on the dashboard will filter to display data only from that time frame.

Navigate To (Interactions)

Use dashboards to launch your users into the rest of your application with the Navigate to URL or Execute Javascript Tile Actions. These actions are contextual so that the URL template or Javascript parameters will pass values based on the values the user selects. For example, the user may select a customer name from a table tile, this can redirect the user to the customer profile section of your application or open a modal with customer details.

Dashboard Filter Improvements

Enable end-user ability to turn off filters or include blanks in their fitler criteria. This also include some UX enhancements for your end-users.

May 2022

Limit Within Dimensions

On Bar Charts you can now limit groups within each dimension or across all dimensions. This means that each bar can show the top 5 groups per dimension instead of the top 5 groups from the entire data set. This option is on the Tile Data Tab.

Preview Profiles

Create a Profile to view data and test row-level security. You can create a Preview Profile from the Preview section of a Collection. These profiles use static values to apply your row-level security rules and are available on any collection in your environment.

Multi-Factor Authentication

MFA is now required for accounts to enhance customer security. The default option is an authenticator app but you may add SMS as a backup.

Currency Symbol Override

Update the currency symbol displayed by passing the appropriate symbol via SDK. This works like timezone conversions and design theme overrides.

Reusing Aggregated Measures in Data Views

When selecting input columns for Data View transformations, aggregated measures are now available as an option. For more information on aggregated measures see the documentation here.

April 2022

Pivot Tables

Displaying data just got easier with Pivot Table Tiles!

Slack Notifications

Get Notified of any errors in your Slack workspace. To see how to set up these alerts check out the documentation here.

Time Zone Conversion

Give users the option to control the timezone in which they view data. By Default data is in UTC but their local browser time is always available as the next option.

If desired, time zones may be controlled via SDK. View docs here

February 2022

Design Theme Enhancements

Apply design themes to the same collection based on the end-user viewing the dashboard. This will make it simpler to customize the experience for end-users without requiring duplication of dashboards.

Learn more about how design themes work

Integrations

There are 2 new integrations available this month

  • Firebase - Cloud Firestore - Build your customer-facing dashboards on top of Firestore in a few minutes.

  • Snowflake - Build a better, more performant dashboard by bringing data together from Snowflake and your application databases.

January 2022

Reference Lines

Add reference lines to axis charts to display aggregate values, goals, and trends.

Integrations

Build your customer-facing dashboards on top of Supabase. See the Verb Supabase Docs

December 2021

Tile Actions

Tile Actions make your collections… actionable. End-users will be able to drill into data, expand tiles, control filters and navigate to other areas of your system. The goal is to make Verb collections feel even more native to your system and give your end-users the ability to discover more. We will be releasing the tile action features in steps. The first available is “Open New Tile”.

Open New Tile will allow your users to select a dimension or category and open a secondary (or child) tile with more information. This secondary tile will display data based on the field selected on the primary (parent) tile.

For example, If we show a bar chart, our user can click that bar and a new tile will open to show data for that bar’s contents.

Check out this video on how to set up an “Open New Tile” Tile Action.

Collection Updates

Add/Remove Rows in the Dashboard Grid

We have made organizing your collection easier with the ability to Add and Remove Rows to the dashboard grid. A plus sign for insert, trash can for delete.

Container Tile, Min Height 3

Containers can now be smaller to better fit into your collection design. Now the containers can be only 3 rows high (instead of 5).

Add New Relative Date Options on Date Filters

Added the ability to filter over the last full week (Sunday- Saturday), as well as the last full month (1st – end). Keep your views consistent based on full week or month data.

Y axis Reset on Cloned Collection.

The Axis will not reset when you have clones. This should help those with a large number of similar collections.

Date Picker issues and Filter Issues

We’ve addressed issues with the date pickers for filters, which should make picking desired dates smoother, and we have simplified how to “apply” to save you a few clicks.

Nested Filters

Dashboard filters are now nested which means that when a filter is applied, the other dashboard filters will only show options that are available for the current results.

For example, if a dashboard date range filter is applied for January the next filter showing Federal Holidays will show MLK Jr. Day in the list but it will not show Christmas because MLK Jr. Day is the only federal holiday in January.

November 2021

System Performance

Collection Publish Process Changes

We’ve altered the publish process to improve the load times of your embedded collections. We expect that you will see significant improvements in the speed of the published/embedded collections.

The publish process may take longer if you have a lot of data in your collection. We included a progress indicator in the collection so that you can follow along if you really want to.

We strongly encourage you to use the recently added collection Preview option instead of publishing every change.

System Level

API Collections - Active Authentication

Previously, the API Collections used Static Auth. You can now use the same auth parameters that are used on dashboards with APIs. This increases the usability of the API collections across many tenants of your application.

Folder Management -

Use folders on Data Sources and Models We’ve added folders to help you organize your data sources and models more easily. Marie Kondo would be proud!

Model and Transformations

You can now expand the data preview tab on the model to a full page view for easier viewing.

We adding searching to the columns which will return the top 100 rows that meet the search criteria (It does not just search the displayed data)

Renaming Columns

On the Select Columns step in a transformation, you can now rename columns for better management and to eliminate duplicates.

Collection Updates

  • Multi-Axis Options

    • We’ve added a new option to treat multiple measures as independent axes on bar and line charts. You no longer need to group measures or use the Alternate Axis option.

    • To use this feature

      • First, add the fields in the measure and join them using an “OR”

      • Then, on the the display tab of the tile, select Independent Axes on the Multiple Axis Options dropdown in the Display Section.

Loading Animation

We’ve updated the loading animation on all tiles to improve the UI design and overall user experience. Let us know what you think!

End-User Data Export - Increased Max Rows

We’ve updated the max number of rows included in the tile data export from 10K to 500K.

Design System Updates

We’re continuing to refine our design system to help keep our UI clean and consistent. You may notice new table and button styles. Please let us know if you see any weirdness.

October 2021

Environment/System Level

Embedding with iFrames

We still suggest embedding via SDK when possible but you can now embed dashboards with an iFrame and segment data with iFrame keys. To access this go to the Settings section in your environment.

Back button in Header

It’s a minor update but the back button in the navigation header will bring you back to the environment section you were previously on with the previous search results instead of always bringing you to the overview section.

Data Sources

Version static files

You can upload new versions of the same static file. We will be adding additional validation soon so please ensure that your file has the same columns and column naming for now.

We will also add column mapping as part of the versioning process in the near future.

New Integrations

Outbound APIs

Connect to a RESTful API with our Outbound API connection.

If you know anyone using Elastic let them know about our newest integration.

Google Big Query

If you know anyone using BigQuery let them know about Verb.

Model

Preview Data - See the first 100 rows of any table in your model.

Advanced Search (coming soon) - You will be able to search the table data beyond the first 100 rows.

Aggregated Measures - Special type of calculated column that’s aggregated against the resulting data set during visualization instead of per row

Useful when you need to calculate an aggregate (i.e. average) taking into account all filters and groupings. For example, calculating a conversion rate on a data set of events needs to happen on all rows that are part of the resulting query instead of per-row.

Transformations (Views and Columns)

Paste Map Values

To save time when mapping values you can past in values from a spreadsheet.

Collections

Preview function - You can now view a live preview of a collection in a separate tab.

Responsive previews - see how collections will look on multiple screen widths

Preview Profiles (coming soon) - You will be able to apply the row-level security rules with a static profile using the request parameters. This means you can preview your dashboard and the data as a user would see it before publishing or embedding.

Video Explanation - https://www.loom.com/share/518ebbf4f0b143569af3191fb2f90b69

Editing View

The filters tab and the collection tab are now the same editing view. This makes editing collections a bit more fluid.

Axis Scale

You can now select between linear and logarithmic scales on axis charts.

  • Filters

    • Styling

      • We’ve updated the filter styles to inherit more properties from your design theme so it matches your collection.

      • The filter section now has formating options to control the wrapping of filters and there’s a new ‘more’ button option when there are many filters on your collection.

      • Hidden filters are no longer shown to admins in the filter area. There is a small flap in the top right to access these filter options in case you want to edit the default.

    • Filter Control Styles

      • There are new filter design options

        • Text filters

          • Improved multi-select functionality

          • Button List

          • Radio buttons

        • Number Filters

          • Slider

      • Ordering and organizing filters

        • The filter panel now allows you to organize filters easily with drag and drop functionality. Depending on the type of embedded filter display the options for filter locations may be different.

    • Embed options (coming soon)

      • We are improving the embedding options by adding additional functionality.

        • Embed With Collection - this includes the filters in the same embed code as the dashboard tiles.

        • Separate filter script - this will provide a second script in the embed instructions to allow a filter to be embedded separately from the tiles.

        • Control via SDK - filters will not render in the embed script. Your system will be responsible for passing these values.

          • When this is enabled there will be a small flap in the top right of the collection editor that opens a modal to configure filters and see the results while editing the collection.

Tile Edit Mode

When editing a tile you can now control the dashboard level filters to see how the impact the tile. If this tile is not connected to the filter then the filter will be disabled.

Download Report in the filter area

You can add a download report button to the filter area of a dashboard. This keeps things a little more organized.

You can add multiple reports to the same download filter button in the filter area. This means that when the end-user selects the download button they will be prompted with a selection of which report they want to download.

Video Explanation - https://www.loom.com/share/7e993bcf74f84a9abd7e70e5f0e1222e

Last updated