Skip to main content

Exclude multiselect values in chart


Forum|alt.badge.img+3

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

Forum|alt.badge.img+5

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

 


Forum|alt.badge.img+3
  • Author
  • New Participant
  • 3 replies
  • February 16, 2023

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. 


Reply