Feature Description
Current calculation options are missing some keylogical operators which should be added such as:
-IF + Nested IF
-EXIST / IN
-NOT / AND / OR-GT / LT / GTEQ / LTEQ
-CONCAT
-SUBSTRING
-CONVERT
-ADDTIMESPAN
Reason
To beable to calculate metrics and dimensions . Current capabilities are fine for an elements edition but for a productive project using a SAP connection its very limited.
Thank you for filing this idea. In 2021Apr we have implemented "Free calculations" to calculate new KPIs and dimensions using an easy to use graphical editor. Furthermore in 2021Jun we implemented the Data Transformation Engine, which allows you to further transform your data.
will be released in 2021Apr
I think the add timespan would be one of the most important since we're in a scenario where customer provides csv files (so some transformations can be realized before csv export from source system) and this would enable users to prioritize or identify where the problems are using a calculated due date.