Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Exclude multiselect values in chart

Topic Labels: Interface Designer
918 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Devorah_Mandelb
4 - Data Explorer
4 - Data Explorer

I have a lookup field on my clients table that lets me know what type of service they received. This is a lookup from a multiselect (the client can get more than one type of service in a single session). I need a pie chart to show me how many clients received specific services. Is there a way to filter out only the categories that I want from the lookup field?

Ex:

Client----Service

Sam -----Zoom, Customization, Training

Ed ------- Training, Customization

 

I want a chart with only Customization and Training numbers

2 Replies 2
Christian_Sabou
5 - Automation Enthusiast
5 - Automation Enthusiast

You can add a filter with the selector "is any of" and check only the categories you want

Christian_Sabou_0-1676557757248.png

 

Devorah_Mandelb
4 - Data Explorer
4 - Data Explorer

Yes, I have that already. Since this is a multiple select field, it is 'has any of' and other options from the multi select will also show up.