topic Re: Variable Extension: Not working Correctly for Set expression in Integration, Extension & APIs

Variable Extension: Not working Correctly for Set expression

sarasmonu — Sat, 16 Sep 2017 13:15:58 GMT

Hi All,

I have a requirement to create 2 measure. When i choose measure 1, the corresponding data is shown in a bar chart. Similarly when measure 2 is chosen the corresponding data is displayed. I want these 2 measure to be present in a filter object. Please let me know if there is any work around available for this.

Thanks,

Monu

Re: Variable Extension: Not working Correctly for Set expression

sarasmonu — Sat, 16 Sep 2017 13:46:46 GMT

Adding to the above, i tried the variable extension but when the value that i need in the variable is set expression, it isnt showing the data correctly, it is just aggregating the data and shows same value for all data points.

Please help as soon as possible.

Thanks,

Monu

Re: Variable Extension: Not working Correctly for Set expression

rubenmarin — Sun, 17 Sep 2017 09:49:47 GMT

Hi Monu, you can try using variable extension to switch between 1 and 2 (simple numbers), and use the variable as a condition in chart expression:

Pick(varName

, // Expression for 1

, // Expression for 2

)

Pick returns the expression in the position asked by the first parameter:

Help - Pick()