Multi Select Filter off comma separated values

Multi Select Filter off comma separated values

Hey friends!

I have a query table for a couple of dashboards/ charts. In one of the dashboards, I'm trying to create a multi select filter for the service that is being sold. The way we look at services is by a CRM field titled, "Mail Lead Entities," "eBill Lead entities," etc. 

In my Query Table, I have the following case:

Case
When L."Mail Lead Entities"  > 0 then 'Mail'
When L."eBill Lead Entities"  > 0 then 'eBill'
When L."Pay Lead Entities"  > 0 then 'Pay'
When L."FlexPay Lead Entities"  > 0 then 'FlexPay'
When L."Collections Lead Entities"  > 0 then 'Collections'
End as 'Service',

Obviously adding a multiselect filter for Service won't work properly as this new Service column will only ever have one of the services listed, when it is indeed possible (if not likely) to have multiple services in a single lead. Is there any way to accomplish what I'm trying to do?

Let me know if question is not clear.

Thanks! 

    • Sticky Posts

    • What's New in Zoho Analytics - February 2026

      Hello Users! We're back with another round of updates for Zoho Analytics. This month's release focuses on giving you greater flexibility in how you visualize, manage, and act on your data - with new features like custom visualizations, remote MCP server,
    • What's New in Zoho Analytics - January 2026

      Hello Users! We are starting the year with a strong lineup of updates, marking the beginning of many improvements planned to enhance your analytics experience. Explore the latest improvements built to boost performance, simplify analysis, and help you
    • What's New in Zoho Analytics - November 2025

      We're thrilled to announce a significant update focused on expanding your data connectivity, enhancing visualization capabilities, and delivering a more powerful, intuitive, and performant analytics experience. Here’s a look at what’s new. Explore What's
    • What's New in Zoho Analytics - October 2025

      Hello Users! We're are back with a fresh set of updates and enhancements to make data analysis faster and more insightful. Take a quick look at what’s new and see how these updates can power up your reports and dashboards. Explore What's New! Extreme
    • What’s New in Zoho Analytics – September 2025

      Hello Users!! In this month’s update, we’re raising the bar across multiple touchpoints, from how you bring in data, plan and track projects to how you design and brand your dashboards. We’ve added the all-new Gantt chart for project visualization, expanded