Feb 16, 2023 06:23 AM
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
Feb 16, 2023 06:30 AM
You can add a filter with the selector "is any of" and check only the categories you want
Feb 16, 2023 06:41 AM
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.