Chart using multiselect

App Building
1

Hello, guys

I am trying to make a chart using multiselect input box. As you see the attached file, my multiselection input area should have "service_type_seq" which in the field of client_requests Table for user to pick whatever he/she wants.
what I should do to do it?
Thanks in advance.

image
image1998×961 90.3 KB

2

Hi @tax

First: you should use multiselect1.value that contains only the selected value.
Second: since it's a multivalue, the WHERE statement should be something like ... service_type_seq = ANY ({{multiselect1.value}})

Hope this help