The new Custom Report Builder, a.k.a. Advanced Builder, appears intended to replace the Cross-object report builder but is missing some functionality. My use case: I have a report that flags any contacts that have more than 30 days between their last activity date and the next scheduled follow-up date, so we can enroll them in a marketing email workflow in the interim. I created a report in the old cross-object report builder to surface such contacts. It used a filter on a deals property that is a calculated Time Between field type. The filter looked like this, and it worked fine: This week when I rebuilt this report in the new Custom Report Builder, I found that I no longer have the option to choose between days, hours or minutes in the filter for this property. Instead, bizarrely, I have to convert the days to milliseconds to achieve the same result. Must convert days to milliseconds in this filter This is clearly a loss of functionality that was present in the old report builder. There is no messaging to indicate that I have to convert the Time Between to milliseconds, so this is a big impact on customer experience for anyone (like me) trying to figure out why their report doesn't work in the new custom report builder. The new custom report builder needs to have the option for days, hours and minutes in filters of Time Between properties, and not just milliseconds. Thank you.
...read more