PowerMetrics Changelog - 2024

New:

• Building perfect visualizations just got easier! Go into Explorer, dashboards, and metric overviews to see our great new customization options for single and multi-axis bar, line, and combination charts. Get creative by modifying line styles, hiding or showing gridlines, axis lines and axis values, creating custom axis labels, and setting adaptive value ranges.

New:

• Date offsets in calculated metrics: You can now use metric data from other time periods in your calculations. Learn more about creating and editing calculated metrics.

• Improved filtering: We’ve made it easier than ever to see and modify the filters applied to visualizations in metric overviews, Explorer, and on dashboards!

New:

• Conditional filtering: Our new, intuitive design lets you filter dimensional data by member or by condition.

New:

• Enhanced metric configuration: When creating and editing metrics, you can now pre-filter which data to include and choose how dimensions can be used. You can also control which dimensions are included for calculated and dbt Semantic Layer metric visualizations.

New:

• Live embedding: Display dynamic versions of your metric visualizations externally in a website or custom data app. Learn more.

• Account usage: Admins can now view usage (and limits) for account assets, like metrics and users, and see the hourly data ingestion for data feeds. Learn more.

New:

• PowerMetrics Query Language: With PowerMetrics Query Language (PMQL) you can extend the value of metrics to external applications, like Enterprise BI, data apps, data orchestration tools, notebooks, and analysis tools - no deep integration or plug-in required! Learn more.

• Microsoft Azure Synapse Analytics integration: A new addition to our expansive list of data warehouse integrations - Microsoft Azure Synapse Analytics! As with all our warehouse services, you’ll benefit from secure data storage, data governance, single source of truth data, and high scalability. Learn more.

• Support for Amazon Aurora: The most recent addition to our ever growing list of data warehouse integrations! Get secure data storage (in your Aurora warehouse), data governance, single source of truth data, and high scalability. Learn more.

• Add precision to your duration metrics: When creating or editing metrics, you can now specify a maximum and minimum time duration to display in your visualizations.

New:

• Decimal places setting: When you create or edit metric visualizations, you can now choose the “Auto” setting (4 decimal places) or display up to 9 decimal places.

• Multi-metric filtering: It’s now easier to apply filters on a per-metric basis for multi-metrics in Explorer and on dashboards. Learn more about multi-metrics.

• Shorten long numeric values: Simplify and add clarity to your visualizations with the new abbreviate long values setting.

• Sample metrics: Want a risk-free way to explore PowerMetrics before diving in and connecting to your data? Check out our sample metrics! Managed by Klipfolio, they behave the same way as metrics you create using your own data. Learn more.

New:

• Switching metric data sources: Making changes to your data stack? Whether you’re moving from data feeds to a data warehouse or from a data warehouse to a semantic layer (or something else entirely), PowerMetrics goes with you. We’ve made it easy to point existing metrics to new, different data sources and smoothly transition your metric data. All this, without affecting existing visualizations, dashboards, goals, or sharing rights. Learn more.

• Visualization chart type and style options: The UI when choosing a metric visualization’s chart type and style has been updated to use a drop-down list. This new, intuitive, more descriptive design makes it even easier to select the perfect format for visualizing your metrics.

New:

• Announcing support for Microsoft Azure SQL: The most recent addition to our ever growing list of data warehouse integrations! Get secure data storage (in your Azure SQL warehouse), data governance, single source of truth data, and high scalability. Learn more.

New:

• Total values for tables: We’ve added a new “show totals” option to list and pivot tables. On by default, when enabled this setting displays total values for columns and rows (in pivot tables) and columns (in list tables).

• Have a conversation with your data! PowerMetrics AI brings self-sufficient data analysis to business users. Our new AI experience, with its intuitive design and natural language interface, helps you explore your data, generate visualizations and get contextual, accurate answers. Learn more.

New:

• Announcing our Cube integration: Connect to data in your Cube semantic layer and add custom metrics to your catalog in PowerMetrics. Defined metrics, security, and governance for data teams - self-serve, single source of truth data for business users. Learn more.

• Great news for our data warehouse customers! Announcing direct to warehouse integrations for six popular services: Google BigQuery, Snowflake, Databricks, Amazon Redshift, PostgreSQL, and MariaDB. These new integrations give you secure data storage (in your warehouse), data governance, single source of truth data, and high scalability.

• Introducing PowerMetrics Assistant: Working in PowerMetrics and have questions? Get answers with our new PowerMetrics Assistant! Learn more.

• New aggregation types: When working with metrics that include transactional data, you now have the option to aggregate values as a cumulative sum or a cumulative count.

New:

• Account-wide search: Our new Search feature is a fast way to find, view details for, and go to metrics and dashboards in your account. Learn more.

New:

• Change metric dimension names: The option to change dimension names makes it easier than ever to compare and analyze visualizations on dashboards with shared filter controls. Learn more.

• Select a theme for published views: When sharing a dashboard as a published view, you can now select the theme you want it to be viewed in (Dashboard theme, Dark theme, or Light theme). Learn more.

New:

• New role for dashboard builders: We’ve added a new built-in role to PowerMetrics. The Contributor is designed for those of you who work almost exclusively with dashboards. With this role, you’ll be able to view and share metrics and view, create, edit, share, and delete metric dashboards. Learn more.

New:

• Setting the first day of week: You can now select which day to use as the first day of the week for your account. Your selection applies to metric visualizations with a weekly periodicity. Learn more.

• Custom metrics for Zuora: We’ve added support for Zuora in PowerMetrics. Start tracking your Zuora subscription payment data with custom metrics, built by you using our visual (and powerful) query builder! Learn more.

New:

• Table configuration options: We’ve added the option to wrap text in tabular charts and to define the number of wrapped rows in pivot tables.

• Custom metrics for Smartsheet: We’ve added support for Smartsheet in PowerMetrics. Start tracking your Smartsheet project management data with custom metrics, built by you using our visual (and powerful) query builder! Learn more.

New:

• Customized metric icons: Add context, align similar data sources, change the look and feel of your metrics – all with customized metric icons! Learn more.

New:

• Sharing:
  • You can now select multiple metrics from your Metric List page and share them all at once. Learn more.
  • Account Admins can now invite new users to the account while sharing. For management purposes, we've also made it easier to find metrics that aren't shared with you. Learn more.

• User and group management:
  • When inviting users to your account:
    • You can also add them to a group. Either add them to an existing group or to the new default group we just released for all new Klipfolio accounts. Learn more.
    • For accounts with access to both PowerMetrics and Klips, you can now allow and restrict product access by user. Learn more.