Hi all! I noticed that even though referencing properties are completely supported for calculated properties there is a big lack of functions that restricts the immense potential that could've been. I know atleast two things that I wish for on the monthly when dealing with calculated properties. 1. We do not have a case_when() / switch(). If you want to categorize something you will have to use nested if() functions... basically one if() function for each distinct category option, which becomes very quickly illegible. 2. We do not have any functions that are dynamical in relation to time dimensions. If I would like to have a categorization dependent on current time (e.g. recent customers are when close date is in year(today())), I will have to hardcode the time I would like to base my condition on (in the example at current writing "2024"). And every new year I would have to change the calculated property, since it is hardcoded... Here functions like "today()", "lastXtimedim(X,timedim)" would be very nice to have. I think calculated properties could become a very essential/value creating tool which in turn would enable/expand a lot of other options for workflows as well if we get more extensive functions to work with (once they work in these aspects). All the best, W
...その他を表示