We would need to know some more about what all of you want NOW() for. The only reason mentioned here is to display the current time to a user in the user interface. If that isallthat is needed it would be better to have a specific UI widget for that. The dashboard only communicates with the data in the model when a user interacts with it, so if it were a cell in a grid showing the result of a NOW function then it would only update when the user interacted.
I suspect that there are other reasons for having a NOW function, and knowing what they are will help in the design. One question that immediately springs to mind is at what granularity should a NOW function change the results it returns. Should it be seconds, minutes, hours? Another is timezone. All Anaplan models run on machines where the clock is set to UTC (Standard time in London). However some models are for users in a different timezone (e.g. Pacific) and some are for users spread across multiple timezones. What would people need? Any variation in this respect would have to be specified in parameters to the function. This is not like Excel where it is on a particular user's machine where the timezone is picked up from the user's operating system.
The granularity is also significant when considering recalculation. When your dashboard reads from the Anaplan model, the server applies any cell updates and then recalculates those cells of the model that have changed as a result. For a model in which there is little data-entry this recalculation will be insignificant and performance will be good. If a NOW function was ticking over every second then the model would need to be updated on每一个interaction. The performance impact of this would need to be considered. We are currently working on the TODAY function which has a number of similar questions. However the granularity of change of TODAY is much less and so the performance impact will be minimal.
As for the mentioned use case in the beginning of this thread, perhaps it is better to be able to use the logging data and have a function to display part of the logging information.
According to my case, I can say that the NOW () function would help track the time in which this or that action worked out, especially when there are more than 10 of them in the process or they are very long.
Waking up and looking at the history or waiting for the backlog of completed processes from the connector is quite inconvenient. When I can make a board in which I can see the current status at the moment. Up to the time of failure (again, this is especially true when your anaplan processes huge amounts of data and twisting the logs in search of an error takes a lot of time and requires a computer, and a phone is enough).
