Expression Issue

Karahs — Sat, 16 Nov 2024 04:50:45 GMT

Hello Everyone,

I have a Pick(Match()) expression which i am using in a Pivot Table wherein i get all my values correctly, the same i want to use in a Combo Chart. But since i have used Pick(Match()) chart shows blank value. I want values to display without doing any selction. I hope i am clear with the question, also attaching the result which i am getting:

Pivot Table

Combo Chart

Expected Result

Expression:

=Pick(Match(_StoreSortOrder,'1','2','3'),

Date(Opening_Date),
num(sum([Days of Operations in the month]),vNumFormat),
Num(sum([No. of Tickets (000)] * 1000)/Sum([Days of Operations in the month]),vNumFormat))

Thanks,

Re: Expression Issue

tresB — Wed, 28 Aug 2019 06:51:13 GMT

Are you using the same dimensions in combo chart as in pivot? Perhaps not. Could you share your sample app?

topic Expression Issue in App Development

Expression Issue

Re: Expression Issue