Number formatting (e.g., percentage) not reflected in chart detail data

Problem

Even when number formatting such as percentage (e.g., “30%”, “55%”) is applied on the chart, the values shown in the “Details” view of the chart display the original unformatted values (e.g., “0.3”, “0.55”).

Cause

The values shown in the Show Detail dialog are based on the original data before any transformations or formatting are applied in the chart. This is expected behavior in Exploratory.

Solution

If you want the formatted values (e.g., percentage strings) to also appear in the chart’s Show Detail dialog, you can create a separate column in advance with those formatted values. For example, you can create a new column like the following to convert a numeric value such as 0.3 into "30%":

paste0(round(target_column * 100), "%")

By doing this, the formatted values will be visible both on the chart and in the Show Detail dialog, ensuring consistency in how the data is displayed.