topic Re: Listing multiple values in a cell of a chart in App Development

Listing multiple values in a cell of a chart

msawyercke — Thu, 22 Sep 2016 13:54:03 GMT

Good Morning,

I have a chart in which I need to list values (unique unit numbers) that 'Fulfilled' an 'Obligation Due' that are required by certain dates.

In the following screen shot, you can see that I can get the unit number to list if there's only 1 unit number that fulfilled a single obligation on that date. However, the chart doesn't list the Unit numbers if there are multiple "Fulfilled' obligations required by a certain date:

Ideally, it would be nice if the multiple fulfilled obligations could be displayed in their appropriate cell and separated by comma.

Thanks for any help/advice you can provide!!

Re: Listing multiple values in a cell of a chart

msawyercke — Thu, 22 Sep 2016 14:48:35 GMT

I'm just using a simple expression, per below:

I'm hopeful there is a function to add into the expression that will allow multiple values in a cell..

Thanks, again!

Re: Listing multiple values in a cell of a chart

stigchel — Thu, 22 Sep 2016 16:24:37 GMT

Try with

Concat([PS # Fulfilled],',')

Re: Listing multiple values in a cell of a chart

Gysbert_Wassenaar — Thu, 22 Sep 2016 16:40:39 GMT

Your expression doesn't explicitly use an aggregation function. In that case the Only() function is used. And the only function can only return a value if there's only one possible value. That's why you see no result for the rows where there are two or more values. If you want a list of values you can use the concat function like Piet Hein van der Stigchel‌posted above..

Re: Listing multiple values in a cell of a chart

msawyercke — Thu, 22 Sep 2016 16:56:19 GMT

Thanks Piet and gysbert,

When I tried Piet's recommendation, this works on individual dates (thanks for that!). But, now the problem is that I have totals turned on in the chart, and there's so many "Fulfilled" unit numbers, it makes the chart unreadable. So, can I now suppress those 'Fulfilled' numbers from listing out in the "totals' line?

Thanks, again!

Re: Listing multiple values in a cell of a chart

stigchel — Thu, 22 Sep 2016 17:52:58 GMT

I'm afraid that I'm not that familiar with Sense, but .... Can you check the Dimensionality() function? It should give another value for the total so you can do something like

if(Dimensionality()>0,...