fschleich
01-15-2024ETL
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