Help

Exclude multiselect values in chart

Topic Labels: Interface Designer
796 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.