Like Ross says in the 90s hit sitcom, FRIENDS, just PIVOT!
So we did. In our March product update, we’re introducing pivot tables, design themes & maps! These enhancements to your Verb dashboards will help not only create a better user experience for your customers, but will also help you in administering your data in an easier fashion.
First up, PIVOT!
Pivot Tables provide multiple layered grouping and summarization of data. They can be used to present and rearrange a lot of information so that end users can dig into more granular data. (And we all know how much we like to dig deeper into our datasets!)
Verb pivot tables are unique because the data can come from any source, structure or unstructured, live or static. Like what you’re familiar with, Verb pivot tables have Rows, Columns and Values. Some rules have been put into place to ensure that the tables are digestible and user-friendly.
See some of our documentation information for more details:
- Rows – There is a maximum of 4 fields as rows
- Columns – There is a maximum of 4 fields as rows
- Aggregate Values – There is a maximum of 10 fields.
- Datetime Fields are unique
- It is possible to add the same datetime field as a row or column with a different aggregation. For example, the event date field may be added 4 times with the aggregation type year, quarter, month, date.
- Sorting on datetime fields is limited to only sort on itself in order to keep dates in sequential order.
Sorting and Limiting
- Limiting data is not yet available on pivot tables.
- Sorting data is available on each row and column field. If the field is not a datetime field then it may be sorted by itself or any of the aggregated value fields
- Verb’s design system shares the standard table and pivot table styles to maintain visual consistency in dashboards. To edit the table theme, select the theme itself and open the table settings option in the data viz section.
Introducing Design Themes
Greater control over the look and feel of your dashboards is super important. Our new Design Themes help live up to that promise. So, what’s a “design theme”?
Design themes are used to control the style of your dashboard and contextual tile collections. By controlling themes independent of collections it allows for more consistent design application across collections. The theme is applied to a collection and some options from the theme are made available at the tile/chart level. Review our documentation on design themes to get more granularity on how they work and how it enhances your user experience!
And last but not least, Maps!
It’s not the Mercator projection, but it’s something, right?
Verb’s map tile displays data across geographic areas by measure or by category. Grouping data by region will display colors according to the respective value. Grouping data by another value will display the largest category in each region.
For example: If the map is showing e-commerce orders by device type (mobile as pink, tablet as purple, desktop as blue), regions will display one of these three colors to indicate the largest sales channel for the respective region. How neat is that?!
Map tiles do not require or use geoJSON (a big plus!), instead location data is mapped to the regions in Verb. Simply select the region type and the field to associate and Verb will plot the data accordingly.
That’s a wrap for March!
We’ll provide you with more product updates along the way. In the meantime, check out our documentation if you’re an existing Verb user or sign up to learn more about how Verb can help you elevate your SaaS application’s analytics experience.