Hey Team - I am trying to add a date field using the now() in the calculated fields. I was wondering if this can be done. I am looking to add a todays date field in pivot table format: Is there a way to add a date field that is not part of the source table?
Hi @Grant_Orchard, looks like you are adding a legacy Business Calculation formula.
The now function is an AQL function and should be added by adding an AQL dimension/measure instead. We will deprecate the Business Calculation function soon to avoid the confusion.
hhmmm okay
We haven’t started using AQL engine yet.
Hi @Grant_Orchard, could you share any challenges you’ve been facing when moving from Business Calculation to AQL Expressions? 