Hi everyone,
I’m working on a MashApp for a Dutch customer, only I’m stuck on a numbering challenge.
This is the case:
The MashApp is based on data from the ARIS Risk & Compliance Manager via the new direct link functionality that’s in from ARCM SR4. There are some widgets created in the MashApp and for some of them I need the functionality of counting the total of Test cases (TC_ID).
In the example above I worked with a number value (Teller) that creates a new column in the data table with the value 1. And at the end I sum all the values 1 in that column and get my total number of test cases (TC_ID).
This works fine if a test case (TC_ID) would only occur ones in the column... But in the ARCM it is possible to at multiple attribute values of the same attribute type to a risk. For example multiple risk types (R_TYPE_NAME) to a risk and the risk data is part of the test case data. Then the test case uses multiple rows in the table because every value combination has to have its own row.
Only than the counting value will be given to both rows and 1 unique test case (example 3454) is counted as 2 test cases.
So my question is how can I create some sort of counting value that only gives his value ones to each unique test case? Or is there a other way of counting the total of test cases and make this also available to filter on other widgets without counting double values.
Hope someone can help me with this problem
Thanks in advance!
Best regards,
Thijs Dirkmaat
.PNG)
.PNG)
