perspective icon indicating copy to clipboard operation
perspective copied to clipboard

Published 20 hours ago • verified publisher icon finos

Percentage formatting

Open fibinger opened this issue 1 year ago • 1 comments

Feature Request

Description of Problem:

When column shows percentage users prefer to see it as percentage (x * 100). Currently we cannot tell Perspective that a particular column represents percentage.

Potential Solutions:

  1. Schema may be introduced with a new data type (apart from existing 'float' and 'integer) called 'percent'.
  2. Other solution would be to add ability of specifying a custom (or built-in) value formatters on per-column basis.

fibinger avatar Oct 11 '23 13:10 fibinger

In aggregate or group by, how could you get a new columnC with values as "sum(columnA) / sum(columnB)"?

hengaini2055 avatar Dec 17 '23 03:12 hengaini2055

Percent format (with or without Expression Columns) is available in v2.9.0, added in #2563

texodus avatar Mar 12 '24 18:03 texodus