fschleich's avatar
01-15-2024
Status:
Needs Votes & Comments

Formula - Having string functions / Applicable to dimensions

Hello,

I would like to porpose the following regarding formulas :

- beeing able to defined formulas in the line or column section (for widget "pivot table"). Functions like SUBSTRING, LEFT, RIGHT, or CONCAT in order to reformat the content of a dimension also beeing able to use CASE function (to build buckets).

- beeing able to use string function to define conditions to apply to a dimension.

ie :

CASE [Type]

WHEN "A" THEN price * 09

WHEN "B" THEN price * 08

ELSE price

END

Thank you

1 Comment

  • Status changed:
    New Idea
    to
    Needs Votes & Comments