Ratio in Visualizer

Ratio columns in Visualizer enable you to calculate ratios by defining a Numerator and Denominator.

This approach maintains consistent values at the report, summary, and sub-summary levels when you use ratio-based metrics.

  1. Select Visualizer > Advanced Tools > BQL Editor 2.0.
  2. From Expression Type, click Ratio tab.
Ratio in Visualizer

Example:

  • Numerator: [OrderDate: Sum: Quantity]
  • Denominator: [OrderDate: Sum: UnitPrice]
Note: Ratio expressions are available as report level expressions and as global expressions.