topic Records excluden in chart in Integration, Extension & APIs

Records excluden in chart

jack — Wed, 13 Dec 2023 13:40:49 GMT

I have a listbox with 4 choices in field Website , that wil give if all clicked B , I, X, F wich are the KEY-field in database

chart will show if 1 or 2 or 4 are clicked with right information

but if none is clicked, it will show the records wich not needed in this chart with KEY 'O' in database

instead of leaving chart empty

what to do in chart key field connected to list box wich has now: ='Sales ' & Concat(distinct [Website], ', ')

Aurelien_Martinez — Wed, 13 Dec 2023 14:08:40 GMT

Hi,

You can use a Calculation Condition in your chart like :

GetSelectedCount(Website) >= 1

jack — Wed, 13 Dec 2023 19:58:26 GMT

, it did only work if i set in all colums ,, don't know if there is smarter way, but anyway it works

Thank you for advice , regards Jack