Custom Measures, Arrays, and Web Interface Reports

[bp...@lucravalde.com]

Afternoon,

I was hoping to be directed to some more in depth documentation on custom measures and the scripts used to create them. I have an array widget on a web interface, the first column is the name of a business. I want to sort a web interface report based on each row's individual value for column. When I use the ${myArray.business_name} call as the measure value ("Business Name" as the measure name) the report gets sorted by the entire array not each element in it.

So for example;
Assume there were two submissions to this web interface. The first with only 1 row where the 'Business Name' column's value is 'Disney', and the second with 2 rows where the 'Business Name' column's values are 'Disney', and 'Pixar' respectively. If you create a web interface report and sort by the "Business Name" measure, and display the count, there will be two groups. ["Disney"](1) and ["Disney", "Pixar"](1).

Is there documentation anywhere that can show me the script needed to make this sort as: Disney(2), Pixar(1). Even if that means that when you pull up the screen for the second Disney entry you also see the rows relating to Pixar.

Thanks to anyone who can help,
Brandon

[Tejas Laddha]

Hi Brandon,

It is not possible because whole value is consider as a string. It will always search for the entire string not for the single value.

In that case could you please elaborate your exact requirement so that we can provide you the alternative solutions.

Thanks and Regards,

Tejas Laddha

Fujitsu RunMyProcess

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "RunMyProcess Support Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to supportforum...@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at http://groups.google.com/a/runmyprocess.com/group/supportforum/.
To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/5a7a5127-b3e9-45d6-862d-ef7e4dc9e1c5%40runmyprocess.com.
For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.

[bp...@lucravalde.com]

Hey Tejas,

Not sure how to be more exact. Let me put a screenshot up to help demonstrate. As you can see in this image, the first column of the 'array' is the measure. I am looking for a way to sort by the individual values of the first column rather than by the entire first column itself.

In this example, there are two entries with Disney and then Pixar in the first column, and one entry with just Disney. How can i create the measure so it is sorting by the "Disney" and "Pixar" instead of "["Disney", "Pixar"]