topic Re: Change caption in title text of chart based on variable values in Integration, Extension & APIs

Change caption in title text of chart based on variable values

jack — Wed, 13 Dec 2023 09:39:50 GMT

In chart is based on value of key with a value B','K','X','I' in dimensions

B stands for bread orders, K stands for Kilo orders, X stands for Frozen orders, I stands for Import orders

Would be fine if caption changes by one pick or a mix of more picks

Like this sample if 2 are active

Aurelien_Martinez — Wed, 13 Dec 2023 12:23:07 GMT

Hi,

Have you try a expression like : Concat(distinct [Website type], ', ')

Aurélien

jack — Wed, 13 Dec 2023 12:47:37 GMT

Hello , tried that one, just did show me exactly " Concat(distinct [Website type], ', ')""

even after change to real field name Concat(distinct [Website], ', ')

Then i tried this , but that only works ok is one click is active, thus could you suggest how to

modify it so it will concanate alle clicks ?

below will only work with one active click

=if(IsNull(Website),'All Products ',' Sales for: '&Website)

Aurelien_Martinez — Wed, 13 Dec 2023 12:56:09 GMT

Have you try with the equal sign ?

Like :

='My title ' & Concat(distinct [Website], ', ')

jack — Wed, 13 Dec 2023 13:20:17 GMT

That worked, thanks a lot

Best regards Jack