Skip to Main Content
Preset Feature Feedback
Status Gathering Feedback
Categories Enhancement
Created by Vítor Ávila
Created on Mar 8, 2022

Improve the average calculation on Charts for integer columns

What is the problem or goal the end user is trying to solve or accomplish?

When configuring a metric on a Chart, users are able to use the AVG aggregation:

However, if the column used is an integer, the calculated average will also be an integer. This is not clearly indicated in the metric dialog and can be very confusing to users.

How are they solving it currently?

Users can use CUSTOM SQL to calculate the AVG (with decimals) for an integer column.

What is the recommended solution by the Customer?

If a user configures an AVG aggregation with an integer column, display a message informing that the calculation will return an integer due to a DB limitation, and suggest the user to use CUSTOM SQL instead, if decimals are needed.

  • Attach files
  • +2