Users cannot directly reference Salesforce Custom Metadata Types within Apsona report filters. As a workaround, they must build additional automation, such as using a Screen Flow to update a Custom Metadata record and a formula field on the target object to compare values, then filter the report based on that formula field.
This approach adds unnecessary complexity, requires custom development and maintenance, and makes report configuration less intuitive. Customers would benefit from the ability to use Custom Metadata Type values directly in Apsona report filters, enabling more dynamic and configurable reporting without relying on intermediary flows or formula fields. This would simplify administration, reduce dependency on custom workarounds, and improve the flexibility of report filtering.