Allow more options besides string fields when comparing fields in Report Builder

One thing I really like about Horizon Analytics is that we can now compare string fields (this post probably needs to be updated FYI) to one another. This functionality came in handy for me when comparing two different CSM lookup fields in my org.

However, I’d like to see this functionality expanded. I have a use case where I’d like to compare two different currency fields. If a customer’s Currency A field is greater than Currency B, that’s a potential red flag. It would be awesome if we could easily report on that. Same thing with date fields. The weird thing is HA appears to allow you to choose non-string fields when comparing fields in the filter, but if you click apply, it simply doesn’t work unless you’re comparing two string fields.