Question regarding tables in MashZone

by Mr. Ralph Boon (2010-08-20) in group ARIS MashZone

Hello community,

I'm currently looking into creating a MashApp based on data from the ARCM, getting data out of the ARCM into MashZone works like a charm! However I have run into the following. Below on the right you see a table where I would like to present an overview of the relevant issues.

The data which I now have contains 2 different test cases who share the same issue. The IRO_ID represents the testcase and the IS_ID represents the issue. Since in this case we have the same issue 2 different IRO_ID's are shown (3473, 3459) but I have not been able to show the rest of the issue data.

PS. Looking in the data feed we get the data as we expect it to be. So as far as I can see the problem occurs somewhere else.

Best Regards,

Ralph Boon
 

Comments

by Mr. Christian Neu (2010-08-20)

Would you export and upload your MashUp please?

Best Regards,

Christian
 

by Mr. Markus von den Driesch (2010-08-20)

Could you please check the data type of IRO_ID and IS_ID in your data feed. Most probably it is "Number", because the values in the example contain only digits.

If you assign numbers in a chart and the key is in more than one row, the data will be aggregated, that means that multiple input rows will produce only one output row.

To avoid this aggregation on your issue IDs convert the "Number" into "Text" in your feed. This can be done with the operator "Change column type"

Best regards,

Markus

by Mr. Ralph Boon (2010-08-23)

I received an email from Gerhard Mueller who also mentioned changing the data type. This seems to give the correct results.

Thank you for the help,

Ralph

by Mr. Gerhard Müller (2010-08-24)

Yes, I wanted to be shure, that the format of the ID columns and the aggregation  were the only problems. The feed below leads to the correct result:

It is also possible to change the data type directly in the data source (->configure columns->type as text).