Hello @medpere, are you able to alter the dataset with custom SQL? If you can bring in the OTA % value from your dataset, and not create the value in a calculated field, this function will be significantly easier. Then you could use periodOverPeriodPercentDifference or periodOverPeriodDifference without running into an aggregation errors. I think if your dataset remains as is, and you are building that percent calculation in a calculated field, you are going to run into aggregation errors.
1 Like