Custom Formulas
Create Custom Formulas for Reports & Dashboards
Turn raw database values into useful business metrics with custom formulas in Ubiq. Create calculated fields, transform values, and build the metrics your reports and dashboards need without changing the underlying source data.
- Create calculated metrics from existing data.
- Apply formulas while building reports and visualizations.
- Keep business calculations close to your reporting workflow.
Calculated Metrics
Create the Metrics Your Business Actually Uses
Database tables often store the individual values you need, while business reporting requires calculations built from those values. Custom formulas let you derive useful metrics directly while creating reports, instead of adding a new database column for every reporting requirement. Ubiq allows you to calculate metrics from database data making it easy for business users to get insights from database information.
Build calculations from your existing data
Combine fields and calculations to create metrics that better represent how your business measures performance. Use formulas to derive values for reporting and then visualize the results in tables, charts, and dashboards.
This complements Ubiq's drag-and-drop reporting workflow by giving you more control when the metric you need is not stored directly in your database.
Flexible Reporting
Transform Data Without Modifying Your Source Database
Reporting requirements change frequently. Custom formulas allow report creators to perform reporting-specific calculations without asking developers to alter database schemas or create additional stored fields for every new metric.
Calculate new values
Derive reporting metrics from fields already available in your database.
Keep source data unchanged
Create reporting calculations without adding columns or modifying the underlying data model.
Use results in visualizations
Turn calculated values into meaningful tables, charts, and dashboard metrics.
Report Building
Use Formulas Alongside Visual Report Building
Start with Ubiq's visual report builder, select the data you want to analyze, and add calculations when your report needs a derived value. This keeps routine reporting accessible while still supporting more specific business logic.
When you need direct control over a query, you can also use the SQL query editor. Together, visual report building, formulas, and SQL provide different ways to work with data depending on the complexity of the analysis.
Dashboards & Analytics
Turn Calculated Values Into Dashboard Metrics
A formula becomes more useful when its result is easy to monitor. Add reports containing calculated metrics to your business dashboards so teams can track important measures alongside other operational data. Share reports with calculated metrics to your team and key stakeholders.
Custom calculations also strengthen your broader analytics workflow by helping turn stored data into metrics that are easier to compare, visualize, and interpret.
Reporting Workflow
Custom Formulas Across Your Reporting Workflow
Use calculations across database reports as part of a connected reporting workflow—from preparing metrics to exploring, presenting, filtering, and distributing the resulting reports.
Related Features
Build More Interactive, Useful Reports
Tutorials
Continue Building With Ubiq
Use these tutorials to turn your data and calculated metrics into useful visual reports.
Supported Data Sources
Use Ubiq's custom formulas to create calculated fields and metrics in reports built from supported relational databases. Perform custom calculations, analyze business data, and generate meaningful insights from your connected data sources.
MySQL
Add custom formulas in MySQL reports to calculate business metrics, create derived values, and analyze database information.
PostgreSQL
Apply custom calculations to PostgreSQL reports using calculated fields and formulas to analyze performance and business trends.
SQL Server
Use custom formulas to create calculated metrics in SQL Server reports and transform raw database values into meaningful business indicators.
MariaDB
Define formulas and calculated fields to create calculated metrics in MariaDB reports for tracking business performance and analyzing database data.
Amazon RDS
Perform custom calculations on data stored in supported Amazon RDS databases using Ubiq's formula-based reporting tools. Easily create calculated metrics in Amazon RDS reports, analyze business performance, track key indicators, and generate meaningful insights from your data.
Amazon Aurora
Use calculated fields and custom formulas to derive business metrics from supported databases. You can create calculated metrics in Aurora reports to analyze revenue, performance, and other business measures.
Build Reports With the Metrics That Matter
Create reports and dashboards from your business data, add custom calculations, and turn raw values into metrics your team can use.
Try Ubiq